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-14
S
SQL/MX compiler (continued)
running
COBOL 16-25
C/C++ 15-30
specifying alternate location 15-34,
16-29
SQL/MX conversational interface
(MXCI) 1-1, 13-7
SQL/MX preprocessor
C 15-8
COBOL 16-9
functions 15-9
invoking 15-40, 16-37
OSS-hosted, COBOL 16-13
OSS-hosted, C/C++ 15-16
Windows-hosted, COBOL 16-18
Windows-hosted, C/C++ 15-21
SQL/MX programs
building and running in Guardian
environment 15-58, 15-60, 15-62,
16-44, 16-45
compilation methods
COBOL 16-2
C/C++ 15-2
description of 1-12
running 15-65, 16-49
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
Static cursors (continued)
opening 6-5
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