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-14
S
SQL/MX compiler (continued)
specifying alternate location 15-31,
16-26
SQL/MX conversational interface
(MXCI) 1-1, 13-7
SQL/MX preprocessor
C 15-8
COBOL 16-9
functions 15-9
invoking 15-37, 16-34
OSS-hosted, COBOL 16-13
OSS-hosted, C/C++ 15-15
Windows-hosted, COBOL 16-16
Windows-hosted, C/C++ 15-20
SQL/MX programs
compilation methods
COBOL 16-2
C/C++ 15-2
description of 1-11
in Guardian environment
C programs 15-54
COBOL programs 16-40, 16-41
C++ programs 15-55
C/C++ programs 15-53
running 15-58, 16-44
Static cursors
authority to use 6-14
closing 6-11
declaration of 6-4
declaring host variables for query
expression 6-4
description of 1-5, 6-1
examples
date-time, nonstandard 5-4, 6-13
date-time, standard 5-3, 6-12, 7-9
interval 5-4, 6-13
fetching within transaction 6-14
initializing host variables 6-5
lock mode considerations 6-15
opening 6-5
Static cursors (continued)
processing retrieved values 6-7
retrieving values 6-6
sample program
C A-1
COBOL C-1
statements using 6-1
steps for using 6-2, 6-3
Static rowsets
See also Rowset arrays
C example of 7-3
COBOL example of 7-3
considerations for size 7-3
declaring host variable arrays 7-2
description of 7-1, 7-2
limiting size of input rowset
examples of 7-22, 7-23
when declaring a cursor 7-23
limiting size of output rowset, examples
of 7-24
restricting size 7-20
rowset-derived tables
specifying, syntax for 7-28
using in DML statements 7-29
selecting with rowset cursor 7-12
C 7-12
COBOL 7-13
specifying row ID 7-20
static cursor, example of 7-9
syntax diagram for host variable
array 7-3
using the index identifier, examples
of 7-25
Stored procedures (SPJ) statement 2-12
Syntax
C host variable data types 3-2
COBOL host variable data types 4-2
SYSTEM_DEFAULTS table 8-6