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-5
D
DELETE statement (continued)
searched form
rowsets 7-19
syntax 5-12
DESCRIBE statement
description of 12-10
INPUT form 10-4
OUTPUT form 10-7
Descriptor
See also Diagnostics area
allocating 10-3
deallocating 10-3
description of 10-1
input parameters 10-3
output variables
description of 10-7
retrieving values of 10-7
setting input data values 10-4
setting input parameter 10-6
specifying output with dynamic
cursor 11-10
using descriptor areas
sample program, C A-17
sample program, COBOL C-9
Diagnostics area 13-13
Diagnostics statement 2-8
DLL file
COBOL 16-16
C/C++ 15-20
DML
See Data Manipulation Language
(DML)
Dynamic cursors
closing 11-6
declaration of 11-4
declaring host variables for 11-4
description of 11-1
initializing input parameters 11-5
opening 11-5
preparing query expression 11-4
Dynamic cursors (continued)
processing retrieved values 11-6
retrieving values 11-5
sample program
C A-15
COBOL C-13
steps for using in C 11-2
steps for using in COBOL 11-3
using 1-7
using descriptor areas, example 11-10
Dynamic input parameters 11-5
Dynamic recompilation, SQL/MX 15-27,
16-22
Dynamic rowsets
DESCRIBE statement 12-10
description of 12-1
descriptor fields, setting 12-5
example of A-26
GET DESCRIPTOR statement 12-9
matching compile-time specified length
with execution-time length 12-4
preparing an SQL statement 12-2
rowset parameter, specifying 12-3
use restrictions 12-1
using SET DESCRIPTOR
statement 12-5
with argument lists 12-5
Dynamic SQL
advantages of 9-1
allocating SQL descriptor area for input
parameters 10-14
allocating SQL descriptor area for
output variables 10-15
assigning input value to DATA within
SQL descriptor area 10-17
constructing statement from
input 10-14
cursors 11-1
deallocating resources for prepared
statement 10-20