SQL Programming Manual for TAL

Index
HP NonStop SQL Programming Manual for TAL—527887-001
Index-4
E
DEFINEs, TACL (continued)
set by RECOMPILE option 5-9
using for SQL compilation 5-8
using to maximize local autonomy 5-28
using with INSERT statement 3-20
using with SQL compiler 5-32
using with TAL compiler 5-31
DEFINE, TAL declaration 3-2
DEFMODE option, TACL 5-32
Delete operation
multiple rows 3-14
set of rows 3-15
single row 3-14
DELETE statement, SQL 3-13
DESCRIBE INPUT statement, SQL 3-16
DESCRIBE statement, SQL 3-16
DETAIL option, FILEINFO command 5-22
Directives
BEGIN DECLARE SECTION 3-6
END DECLARE SECTION 3-6
NonStop SQL
table of 1-3
TAL compiler 5-4
Disk process (DP2) 4-3, 4-9, 4-14
Distributed database, maximizing local
autonomy 5-28
DROP statement, SQL 3-17
DUPLICATE command, FUP 5-22
Duplicating SQL files, effect on SQL
validity 5-22
Dynamic memory allocation 7-14
Dynamic operations
SQL compilation 5-14
Dynamic SQL operations
applications for 7-2
compilation 5-14
conversational interface for 7-2
declaring the names buffer 7-5
declaring the SQLDA 7-5
description 1-5
Dynamic SQL operations (continued)
getting information about 6-13
overview 7-1
programming techniques 7-7
sample program C-1, C-9
single-code thread design for D-14
specifying input parameters 7-4
specifying output parameters 7-4
SQLDA version format D-14
using a parameter 2-23
using a parameter list 2-24
using DESCRIBE and DESCRIBE
INPUT 3-16
using EXECUTE IMMEDIATE 3-18
version issues D-7
writing a Pathway server 7-3
E
ELSE TAL keyword in SQL statements 3-1
Embedded SQL statements
advantages 1-1
in TAL source file 1-2, 3-1, 3-2
END DECLARE SECTION directive,
SQL 1-3
, 2-2, 3-6
End of line, in SQL statement 3-2
END TAL keyword in SQL statements 1-2
Enscribe database
data file for 2-13
memory use by program 5-32
utilities protection for SQL objects 5-22
Equivalenced local structure as host
variable 2-12
Error processing
using SQL procedures for 4-1
using SQLCODE for 6-1
using WHENEVER for 6-4
Errors and error messages
for DELETE statement 3-13
for FETCH statement 3-18
for INSERT statement 3-19