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-12
Q
Preprocessor (continued)
OSS-hosted
COBOL 16-9
C/C++ 15-8, 15-16
Windows-hosted
COBOL 16-16
C/C++ 15-20
Program compilation
C and C++ 15-2
COBOL 16-3, 16-6
C/C++ 15-6
embedded module definitions 15-3,
16-3
module definition files 15-6, 16-6
Program management
description of 17-1
managing files 17-3
Program management, debugging 15-60
PROTOTYPE host variables
example of 5-18
syntax 8-4
using as table names 5-18
Q
Query execution plans
displaying 15-60, 16-45
displaying for all statements 15-62
displaying for one statement 15-61
wild cards 15-63
R
RDF
See Remote Database Facility (RDF)
Record descriptions, COBOL 4-9
Redefinition timestamp, tables 8-9
Remote Database Facility (RDF)
deploying static SQL to 15-49
object naming considerations 8-7
ROLLBACK WORK statement 6-11
Rowset arrays
as input for SELECT statements,
examples of 7-11
description of 7-2
examples of 7-4
inserting rows from 7-14
selecting rows into 7-6
specifying size and row ID 7-20
syntax 7-4
updating rows with 7-17
using for input 7-5
using for output 7-6
using in DML statements 7-6
ROWSET FOR clause 7-20
Rowset parameter
basic dynamic rowset, example 12-3
mixing scalar and rowset host variables,
example 12-3
specifying 12-3
using FOR INPUT SIZE and KEY BY,
example 12-4
Rowsets
See also Dynamic rowsets, Static
rowsets, Rowset arrays
difference between static and
dynamic 12-1
dynamic SQL
description of 12-1
descriptor fields
syntax 12-5
example of A-26
selecting into rowset arrays 7-6
specifying rowset arrays
example of 7-4
syntax 7-4
Rowset-derived tables
available from static rowsets only 12-1
deleting rows by using 7-39
description of 7-28
inserting rows from 7-34