SQL Programming Manual for Pascal

Index
HP NonStop SQL Programming Manual for Pascal—528614-001
Index-6
O
NonStop SQL statements (continued)
comments 3-2
COMMIT WORK 7-14
CREATE TABLE 2-4, 7-2
DECLARE CURSOR 3-3, 3-9, 3-40
DELETE 3-11
DESCRIBE 3-14
DESCRIBE INPUT 2-13, 3-14, 7-23
embedding 3-1
EXECUTE 1-4, 3-14, 7-6
EXECUTE IMMEDIATE 1-4
FETCH 3-17, 3-37, 3-40, 7-5
INSERT 2-8, 2-11, 3-18, 7-6
OPEN 3-28, 3-34, 3-37
placing 3-2
PREPARE 2-13, 3-29, 4-23, 5-15, 7-9
RELEASE 3-29
SELECT 2-8, 3-9, 3-29, 7-4
terminating 3-1
UPDATE 2-8, 3-36
UPDATE STATISTICS 5-15, 5-23, 5-29
NonStop SQL Statements (table) 1-2
NonStop SQL statements, locating
information about 3-3
NOOBJECT option, SQL directive 5-9
NORECOMPILE option, SQL
compiler 5-10, 5-23
NOSQLMAP option, SQL directive 3-36
Not found condition, WHENEVER 6-6
NOT NULL clause, version issue D-4
NOWHENEVERLIST option, SQL
directive 3-36
NULL keyword
with UPDATE statement 3-42
NULL STRUCTURE
with INVOKE 3-27
Null values
handling 7-13, 7-36
in host variables 2-10
in input parameters 7-36
Null values (continued)
in names buffer 7-37
in output variables 7-37
invoking table with 3-26
with parameters 2-13
NULLP value D-6
NULL_INFO field
in SQLDA 7-6
NUM_ENTRIES field
in SQLDA 7-5
O
OBEY command file 5-3
OBEYFORM format report 5-9
Object file
for Pascal compiler 5-2
for SQL compiler 5-6
in RUN command 5-3
SQL compilation 5-31
Object files, handling mixed versions D-11
OBJECT option, SQL compiler 5-9
Objects
handling mixed versions D-11
Version 1 D-1
Version 2 D-1
OPEN statement 3-17, 3-28, 3-29, 3-33
Open tables 5-25
Optimized execution plan
EXPLAIN PLAN report 5-18
SQL compiler function 5-6, 5-11
statistics requirement 5-15
Output variables
allocating space for 7-30
OUTPUT_NUM
in SQLSA 7-6
P
PARAM command 5-13