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-13
S
Rowset-derived tables (continued)
limiting the size of 7-35
updating rows by using 7-37
ROWSET_IND_LAYOUT_SIZE 12-8
ROWSET_SIZE 12-6
ROWSET_VAR_LAYOUT_SIZE
description of 12-6
minimum values table 12-7
Run-time errors, avoiding 15-59
Run-time library, C++ default 15-26
S
Schema declaration 2-7
Scope
flow control 2-13
line order 2-13
Searched DELETE statement 5-12
Searched UPDATE statement 5-9
SELECT statement
examples of 5-2, 7-11
multiple-row using rowsets 7-6
primary key in WHERE clause 5-2
single-row 5-2
using rowset arrays as input 7-10
using to specify a cursor 6-1
SET DESCRIPTOR statement
examples of 10-4, 10-6
using with dynamic rowsets 12-5
SET MPLOC statement 2-11
SET NAMETYPE statement 2-10
SET TRANSACTION statement 14-3
Similarity check
automatic recompilation 8-12
criteria 8-10
enabling, disabling 8-9
purpose of 8-8
Simple statements 5-1
SQL cursors, dynamic 11-1
SQL Declare Section
COBOL 4-1
SQL Declare Section (continued)
C/C++ 3-1
placement of 2-2
SQL descriptor area
description of 10-2
getting information from 10-7
setting information in 10-4
steps for using 10-12, 10-13
SQL item descriptor 10-2
SQL statements
coding guidelines 2-1
dynamic SQL 2-8
executable 2-4
executable in C++ 2-5
nonexecutable restrictions 2-4
preparing with dynamic rowsets 12-2
SQLCODE
declaring 13-5
examples of checking 13-6
using ERROR command 13-8
values 13-5
within SQL/MX messages 13-7
SQLMX_PREPROCESSOR_VERSION,
using to generate module definition
files 17-7
SQLSTATE
checking 1-9, 13-4
declaring 13-1
values 13-2
within SQL/MX messages 13-8
SQL/MX compiler
environment variable for backward
compatibility 15-33, 16-28
invoking 15-38, 16-34
mxcmp command to compile module
definition file 15-31, 16-26
running
COBOL 16-22
C/C++ 15-26