SQL/MP Programming Manual for COBOL

Index
HP NonStop SQL/MP Programming Manual for COBOL—529758-003
Index-4
D
Data structures, internal SQL B-1
Data types, SQL and COBOL
correspondence 2-2
DATA-LEN, SQLDA structure field 10-12
checking 10-21
DATA-TYPE, SQLDA structure field 10-12
checking 10-21
DATEFORMAT clause, INVOKE
directive 2-18
Date-time data type 2-9, 2-18
Debugging
FORCE option 6-36
RUND command 7-2
DECIMAL POINT IS COMMA option,
COBOL 2-8
DECLARE CURSOR statement
description 4-15
example 4-13
guidelines 4-15
placement 4-15
Declare Section
declaring host variables 1-2, 2-1
INVOKE directive 2-13
specifying 2-1
DEFINE format, EXPLAIN report 6-41
DEFINEs
automatic SQL recompilation 8-6
class CATALOG 1-5, 6-9
class MAP 1-5, 2-13, 6-9
DEFMODE attribute 7-2
determining set used 7-2
guidelines 6-9
SQL compiler options 6-28
=_DEFAULTS 6-41
=_SQL_MSG_system 5-2
DEFINES option, EXPLAIN utility 6-29
DEFMODE attribute 6-10
DELETE statement
description 4-10
multirow 4-11, 4-22
single-row 4-11
DELETE statement (continued)
SQLCODE values 4-11
with a cursor 4-1, 4-22
without a cursor 4-1
Delimiters 3-2
DESCRIBE INPUT, dynamic SQL
statement 3-6
DESCRIBE, dynamic SQL statement 3-6
DISC-READS, SQLSA structure field 9-24
Displaying information
SQLCA_DISPLAY2_ procedure 5-4
SQLCA_TOBUFFER2_ procedure 5-11
SQLSADISPLAY procedure 5-27
DML statements
effect of CONTROL directives 6-43
EXPLAIN PLAN report 6-40
DML, SQLSA structure field 9-23
DROP CONSTRAINT, DDL statement 8-5
DROP INDEX, DDL statement 8-5
DROP TABLE statement 4-22
DROP TABLE, DDL statement 8-5
DROP VIEW, DDL statement 8-5
DROP, DDL statement 3-4
Dynamic SQL
declaring host variables 10-10
declaring SQLCA and SQLSA data
structures 10-10
defining storage for parameters 10-11
description 1-6
handling parameters 10-20
indicator parameters 10-9
input parameters 10-6
interface with Pathway 10-35
output parameters 10-7
parameter list 10-7
parameters in a loop 10-8
PREPARE statement 10-18
processing database requests 10-5
processing nonSELECT
statements 10-29