SQL/MX Programming Manual for C and COBOL (G06.24+, H06.03+)

Index
HP NonStop SQL/MX Programming Manual for C and COBOL—523627-004
Index-11
O
NULL (continued)
inserting multiple rows with
using indicator host variable
array 7-15
using indicator host variable array in
rowset-derived table 7-36
keyword instead of indicator
variable 4-20
retrieving using NULL predicate 3-31,
4-21
testing for 3-30, 4-20
NULL STRUCTURE clause 3-37
Numeric host variables 3-5, 4-12
O
OBEY command files, for creating database
objects 2-12
Object name qualification 8-5
Object names, referencing 1-1
Object naming statements 2-10, 2-11
OLT optimization considerations 8-5
OLTP programs, recommended
recompilation settings 8-13
OPEN statement
description of 6-5
syntax 11-5
Open System Services (OSS)
COBOL preprocessing in 16-13
developing native C/C++ with SQL
on 15-44
P
Parameters
dynamic SQL with arguments
description of 9-2
input 9-2
output 9-2
SELECT columns 9-2
using DESCRIBE INPUT 9-2
using DESCRIBE OUTPUT 9-2
Parameters (continued)
dynamic SQL with descriptor areas
description of 10-3
input 10-3
output 10-7
SELECT columns 10-7
using DESCRIBE INPUT 10-3
using DESCRIBE OUTPUT 10-7
Performance
declaring host variables 3-12
COBOL 4-1
C/C++ 3-1
improving with rowsets 1-7
INVOKE statement
C 3-31
COBOL 4-22
OLT optimization considerations 8-5
OLTP settings 8-13
recompiling 15-27, 16-22
rowsets 1-7, 7-1
similarity check 8-8
using a cursor 6-2
PICTURE clause
fixed-length character data 4-11
numeric data 4-12
variable-length character data 4-12
Positioned DELETE statement 6-9
Positioned UPDATE statement 6-8
PREPARE statement
compiling dynamic embedded
SQL 12-2
syntax 11-4
PREPARE string, specifying rowset
parameter 12-3
Preprocess in Guardian environment
C 15-54
C++ 15-56
Preprocessor
interpretation of environment variables,
example of 17-7