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-6
E
Dynamic SQL (continued)
deallocating SQL descriptor area 9-7,
10-20
declaring host variable for
statement 10-14
default value setting 9-8
describing input parameters 10-16
describing output parameters 10-16
description of 1-6, 9-1
executing the statement 10-18
getting COUNT of item descriptor
areas 10-19
getting VALUE of output within SQL
descriptor area 10-19
input parameters in 10-3
parameters 10-3
preparing the statement 9-5, 10-15
rowsets 12-1
setting INDICATOR for null within SQL
descriptor area 10-17
setting values of input parameters by
position 10-17
statements for dynamic cursors,
summary 11-1
statements with descriptors,
summary 10-1
steps for using SQL descriptor
area 10-12, 10-13
using descriptor areas
description of 1-6
sample program, C A-17
sample program, COBOL C-9
with arguments
deallocating resources for prepared
statement 9-7
declaring host variable for
statement 9-4
executing the prepared
statement 9-6
floating-point variables 9-2
input parameters 9-2
Dynamic SQL (continued)
with arguments (continued)
moving statement into host
variable 9-5
output variables 9-2
sample program, COBOL C-6
steps for using 9-3
summary 9-2
using in a C program, example
of 9-3
using in a COBOL program,
example of 9-4
E
Embedded module definitions
compiling, COBOL 16-22
compiling, C/C++ 15-27
Embedded SQL
advantages of 1-1
coding in program 2-1
description of 1-2
executable SQL statements 2-4
general syntax of 2-1
host variable declarations 2-2
MODULE directive 2-2
nonexecutable SQL statements 2-4
placement of 2-5
Embedded SQL application, running
COBOL 16-43
C/C++ 15-58
Environment variable
MXCMP 15-31, 16-26
MXCMPUM 15-31, 16-26
Error conditions 13-1
ETK
See HP Enterprise Toolkit (ETK)
Exception conditions
checking SQLCODE 13-5
checking SQLSTATE 1-9, 13-1
description of 1-9