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

Index
HP NonStop SQL/MX Programming Manual for C and COBOL—544617-003
Index-12
Q
Preprocess in Guardian environment
C 15-60
C++ 15-62
Preprocessor
interpretation of environment variables,
example of 17-7
OSS-hosted
COBOL 16-9
C/C++ 15-8, 15-17
Windows-hosted
COBOL 16-18
C/C++ 15-21
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-67
PROTOTYPE host variables
example of 5-18
syntax 8-4
using as table names 5-18
Q
Query execution plans
displaying 15-67, 16-51
displaying for all statements 15-69
displaying for one statement 15-68
wild cards 15-69
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-54
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