SQL/MP Programming Manual for COBOL

HP NonStop SQL/MP Programming Manual for COBOL—529758-003
Index-1
Index
A
Accelerator
compiling process 1-5
effect on SQL validity 8-2
OSS environment 6-18
OSS environment variable 6-16
to optimize object code 6-14, 6-24
Access authority
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 UPDATE statement 4-8
for an UPDATE STATISTICS
statement 6-35
to run an SQL program file 7-1
to run the SQL compiler 6-25
Access path
determined by SQL compiler 6-26
EXPLAIN PLAN report 6-40
EXPLAIN utility 6-29
unavailable 8-8
ADD command, Binder program 6-22
ADD CONSTRAINT, DDL statement 8-5
Aggregate functions, using in a
program 9-10
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-14
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-30
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-22
BIND command 6-22
BUILD command 6-22
CHANGE command 7-6
guidelines 6-21
OSS environment 6-18
SELECT command 6-22
SQL program file format 6-38
STRIP command 6-22
BLANK clause, host variable
declaration 2-9
Buffer invalidation, cursor operations 4-15
BUILD command, Binder program 6-22