SQL/MP Programming Manual for COBOL

Index
HP NonStop SQL/MP Programming Manual for COBOL—529758-003
Index-3
D
CONTROL TABLE directive
description 3-5
OPEN ALL option 4-2
CONVERTTIMESTAMP, system procedure
and SQL function 4-8
COPY
COBOL statement 6-9
SQL utility 4-2
COST, SQLCA structure field 9-13
CPRL error codes 11-2
CPRL procedures
CPRL_AREALPHAS_ 11-4
CPRL_ARENUMERICS_ 11-5
CPRL_ARE_ 11-3
CPRL_COMPARE1ENCODED_ 11-6
CPRL_COMPAREOBJECTS_ 11-8
CPRL_COMPARE_ 11-7
CPRL_DECODE_ 11-9
CPRL_DOWNSHIFT_ 11-10
CPRL_ENCODE_ 11-11
CPRL_GETALPHATABLE_ 11-12
CPRL_GETCHARCLASSTABLE_
11-13
CPRL_GETDOWNSHIFTTABLE_
11-14
CPRL_GETFIRST_ 11-14
CPRL_GETLAST_ 11-15
CPRL_GETNEXTINSEQUENCE_
11-16
CPRL_GETNUMTABLE_ 11-17
CPRL_GETSPECIALTABLE_ 11-18
CPRL_GETUPSHIFTTABLE_ 11-19
CPRL_INFO_ 11-19
CPRL_READOBJECT_ 11-21
CPRL_UPSHIFT_ 11-22
description 11-1
CPRL-PTR, SQLDA structure field 10-13
CREATE COLLATION statement 11-1
CREATE TABLE statements, example 2-14
CREATEPROCESS, COBOL routine 1-5,
7-3
CREATE, DDL statement 3-4
Cursor operations
CLOSE statement 4-13, 4-23
closing 4-13, 4-23
cursor stability 4-14
DECLARE CURSOR statement 4-15
DELETE statement 4-22
determining cursor position 4-14
dynamic SQL statements 10-30
FETCH statement 4-17
foreign cursors 4-23
guidelines 10-31
OPEN statement 4-16
performance considerations 4-2, 4-15,
4-22
static SQL cursor 4-12
VSBB 4-15
D
Data
deleting 4-22
fetching 4-17
updating 4-8
Data Control Language (DCL)
statements 3-5
Data conversion
between SQL and COBOL data
types 2-5
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-2
statement placement 3-3
Data Manipulation Language (DML)
statements 3-5
Data retrieval statements 4-1
Data Status Language (DSL)
statements 3-6