SQL Programming Manual for TAL

Index
HP NonStop SQL Programming Manual for TAL—527887-001
Index-3
D
D
Data
advantages of NonStop SQL 1-1
conversion between SQL and TAL 2-4
enforcing integrity E-1
using INSERT statement with 3-19
using SELECT statement with 3-31
Data Control Language (DCL) SQL
statements 1-2
Data declarations
BEGIN DECLARE SECTION directive,
SQL 3-6
END DECLARE SECTION directive,
SQL 3-6
tables and views 3-22
Data Definition Language (DDL) SQL
statements 1-2
Data Manipulation Language (DML) SQL
statements 1-2
Data structures, SQL
placing in memory 3-37
Data types
conversion between SQL and TAL 2-4
correspondence (SQL and TAL) 2-2
date-INTERVAL 2-11
date-time 2-4, 2-11
default for dynamic SQL
parameters 2-26
FIXED 2-13
INTERVAL 2-4
literal declarations for 7-21
mapping
with INVOKE 2-20
, 3-23
overriding default types 2-5
SQL 2-2
TAL 2-2
version compatibility D-1
Database, NonStop SQL
sample A-2
using embedded SQL 1-1
DATAPAGES directive, TAL compiler 7-8
DATA^LEN field
in SQLDA structure 7-5
literals for 6-19
DATA^TYPE field
in SQLDA structure 7-5
literals for 6-18
DATEFORMAT clause 2-17
with INVOKE directive 3-24
Date-time
data types for 2-4
data types for host variables 2-15
literals for 6-19
static SQL example B-10
Debugging
using SQLCOMP FORCE option 5-8
,
5-14
with RUND command 5-30
DECLARE CURSOR statement, SQL 3-11
Declare Section 2-2
declaration 3-6
multiple use 2-2
Declare section 1-3
DEFAULT clause, version
incompatibility D-4
DEFAULT SYSTEM clause
for C10 program migration D-4
DEFINEPOOL system procedure 7-17
DEFINES option
for EXPLAIN utility 5-8
for SQL compiler 5-8
DEFINEs, TACL
EXPLAIN report format 5-18
for automatic SQL recompilation 5-25
for catalog name 5-7
for SQL compilation 5-15
for SQL program execution 5-32
for SQL program file 5-30
in sample program C-1, C-10
propagating 5-32