SQL Programming Manual for Pascal

Index
HP NonStop SQL Programming Manual for Pascal—528614-001
Index-2
D
Cursor
CLOSE statement 3-7
closing 7-13
declaration 3-10
DECLARE CURSOR statement 3-9
DELETE statement 3-11
dynamic 3-8, 7-33
FETCH statement 3-17
initialize WHERE variable 3-33
OPEN statement 3-28
opening 7-12
PREPARE statement 3-29
RELEASE statement 3-29
SELECT statement 3-29
static 3-7, 3-9
UPDATE WHERE CURRENT
statement 3-37
when to close 3-34
when to initialize 3-34
Cursor scope 3-33
D
Data consistency 1-1
Data Control Language (DCL)
statements 1-2
Data declaration, Pascal 3-1
Data Definition Language (DDL)
Data Definition Language (DDL)
statements 1-2
Data format
and data integrity E-1
Data integrity
enforcing E-1
Data Manipulation Language (DML)
statements 1-2
Data type correspondence 3-23
Data types, Pascal 2-2
Data types, SQL 2-2
Data types, version compatibility D-1
Data values
and data integrity E-1
Database, sample A-1
DATA_LEN field, in SQLDA 7-5
DATA_TYPE field literals, in SQLDA 6-18
DATA_TYPE field, in SQLDA 7-5
DATEFORMAT clause 3-25
Date-time
data in host variables 2-9
data type compatibility 2-4
literals for SQLDA 6-19
sample program B-6
with INVOKE 3-24
DCL statements
See Data control language (DCL)
Debugging
FORCE option 5-8
SQL compiler option 5-8
with RUND command 5-30
DECLARE CURSOR statement 3-3, 3-9,
3-40
Declare Section 1-3, 2-2, 2-10, 3-6
DEFAULT clause, version issue D-5
DEFAULTS DEFINE
See =_DEFAULTS DEFINE
DEFINEs
for automatic SQL recompilation 5-23
for catalog name 5-7
maximizing local autonomy 5-28
report format 5-18
set by RECOMPILE option 5-9
unresolved for SQL compilation 5-31
using current DEFINES 5-8
using stored DEFINES 5-8
DEFMODE option 5-19, 5-32
Delete
multiple rows 3-12
single row 3-11
DELETE statement 3-11