SQL/MX Programming Manual for C and COBOL (H06.04+)

Index
HP NonStop SQL/MX Programming Manual for C and COBOL—540434-001
Index-14
S
SQL/MX compiler
environment variable for backward
compatibility 15-33, 16-29
invoking 15-38, 16-34
mxcmp command to compile module
definition file 15-32, 16-27
running
COBOL 16-22
C/C++ 15-27
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-38, 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
building and running in Guardian
environment 15-55, 15-57, 15-59,
16-41, 16-42
compilation methods
COBOL 16-2
C/C++ 15-2
description of 1-11
running 15-62, 16-46
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
Static cursors (continued)
examples
interval 5-4, 6-13
fetching within transaction 6-14
initializing host variables 6-5
lock mode considerations 6-15
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