SQL Programming Manual for TAL

Index
HP NonStop SQL Programming Manual for TAL—527887-001
Index-9
O
NOT NULL clause
and version incompatibility D-4
for C10 program migration D-4
NOWHENEVERLIST option, SQL
directive 3-36
NULL keyword
with INSERT statement 2-18
, 3-47
with UPDATE statement 3-47
Null keyword
with INVOKE directive 2-17
NULL STRUCTURE clause
with INVOKE directive 3-27
Null values
handling 7-36
handling for dynamic SQL 7-13
in host variable 2-17
in input parameters 7-36
in names buffer 7-38
in output variables 7-38
version incompatibility D-3
with a parameter 2-26
with INSERT statement 3-20
with INVOKE directive 3-26, 3-27
with UPDATE statement 3-47
NULL^INFO field
in SQLDA structure 7-5
O
OBEY command file
for running TAL compiler 5-3
format for EXPLAIN report 5-19
SQLCI D-5
OBEYFORM option
for EXPLAIN report 5-18
for SQL compiler 5-9
Object file
binding using Binder program 5-4
for SQL compiler 5-6
for TAL compiler 5-3
Object file (continued)
handling mixed versions D-12
in TACL RUN command 5-3
running Accelerator on 5-12
SQL compilation of 5-32
SQL file format of 5-12
validation for 5-22
OBJECT option, SQL compiler 5-9
Object, SQL
changes and program file validity 5-23
handling mixed versions D-12
using DROP for 3-17
version 1 D-2
version 2 D-2
OPEN statement, SQL 3-29
Open statement, SQL 3-34
OPEN system procedure 7-3
Open tables, SQL 5-25
Optimized execution plan
EXPLAIN PLAN report 5-18
SQL compiler function 5-11
statistics requirement 5-11
OUT file
SQL compiler 5-7
TAL compiler 5-3
Output host variable
valid and invalid forms 2-1
Output variable
allocating space for 7-27
displaying 7-27
handling for dynamic SQL 7-11
specifying for dynamic SQL
operations 7-4
Override data types
generated by INVOKE 3-23
INVOKE generated 2-20
syntax for 2-5
table 2-6