SQL/MP Programming Manual for COBOL85

HP NonStop SQL/MP Programming Manual for COBOL85—429326-004
Index-1
Index
A
Accelerator
compiling process 1-5
effect on SQL validity 8-2
OSS environment 6-15
OSS environment variable 6-17
to optimize object code 6-24
Access authority
for a cursor 4-13
for a DELETE statement
multirow 4-22
single-row 4-10
for a FETCH statement 4-17
for a SELECT statement
multirow 4-19
single-row 4-4
for an INSERT statement 4-6
for an INVOKE directive 2-13
for an OPEN statement 4-16
for an UPDATE statement 4-8
for an UPDATE STATISTICS
statement 6-33
to run an SQL program file 7-1
to run the SQL compiler 6-24
Access path
determined by SQL compiler 6-24
EXPLAIN PLAN report 6-38
EXPLAIN utility 6-27
unavailable 8-8
ADD command, Binder program 6-23
ADD CONSTRAINT, DDL statement 8-5
Aggregate functions, using in a
program 9-9
ALTER CATALOG, DDL statement 3-4
ALTER COLLATION, DDL statement 3-4
ALTER INDEX, DDL statement 3-4
ALTER PROGRAM, DDL statement 3-4
ALTER TABLE, DDL statement 3-4
ALTER VIEW, DDL statement 3-4
ARRIVAL-SEQ, SQLCA structure field 9-13
Asterisk
in SELECT statement 4-4
with similarity check 8-13
AUDIT attribute, changing 8-3
Automatic SQL recompilation
AUDIT attribute changes 8-3
causes 8-6
compiler operations 6-28
description 8-5
functions 8-5
NORECOMPILE option 8-6
preventing 8-9
RECOMPILE option 8-6
B
BEGIN DECLARE SECTION
description 3-3
host variables 1-2
specifying 2-1
BEGIN WORK, transaction control
statement 3-7
Binder program
ADD command 6-23
BIND command 6-23
BUILD command 6-23
CHANGE command 7-5
guidelines 6-22
OSS environment 6-15, 6-23
SELECT command 6-23
SQL program file format 6-35
STRIP command 6-23
Binserv
description 6-10
PARAM BINSERV command 6-7