SQL/MP Programming Manual for COBOL85

Index
HP NonStop SQL/MP Programming Manual for COBOL85—429326-004
Index-4
D
Data conversion
between SQL and COBOL data
types 2-4
dynamic SQL statements 2-5
Data Declaration directives 3-3, 3-4
Data Definition Language (DDL)
statements 3-4
Data description clauses, COBOL 2-8
Data Division
Declare Section 2-1
statement placement 3-3
Data Manipulation Language (DML)
statements 3-5
Data retrieval statements 4-1
Data Status Language (DSL)
statements 3-6
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-11
checking 10-21
DATEFORMAT clause, INVOKE
directive 2-18
Date-time data type 2-9, 2-18
Debugging
FORCE option 6-34
RUND command 7-2
DECIMAL POINT IS COMMA option,
COBOL 2-8
DECLARE CURSOR statement
description 4-15
example 4-12
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-39
DEFINEs
automatic SQL recompilation 8-6
class CATALOG 1-5, 6-5
class MAP 1-5, 2-13, 6-5
DEFMODE attribute 7-1
determining set used 7-1
guidelines 6-5
OSS environment 6-6
SQL compiler options 6-26
=_DEFAULTS 6-39
=_SQL_MSG_system 5-2
DEFINES option, EXPLAIN utility 6-28
DEFMODE attribute 6-6
DELETE statement
description 4-10
multirow 4-11, 4-22
single-row 4-11
SQLCODE values 4-10
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-23
Displaying information
SQLCA_DISPLAY2_ procedure 5-4
SQLCA_TOBUFFER2_ procedure 5-11
SQLSADISPLAY procedure 5-27
DML statements
effect of CONTROL directives 6-41
EXPLAIN PLAN report 6-38
DML, SQLSA structure field 9-22
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