SQL Programming Manual for TAL

Index
HP NonStop SQL Programming Manual for TAL—527887-001
Index-5
F
Errors and error messages (continued)
for UPDATE statement 3-42
run-time SQL recompilation 5-28
SQL compiler 5-14
Example programs
static program B-10
static SQL program B-1
Exclamation point (!) for TAL comments 3-2
EXEC SQL keywords 1-2, 3-1
EXECUTE IMMEDIATE statement,
SQL 1-5
, 3-18
EXECUTE statement, SQL 1-5, 3-18, 7-13
Executing a TAL program 1-7
Execution plan
EXPLAIN report 5-18
optimized by SQL compiler 5-11
optimized by statistics 5-11
SQL compiler function 5-11
EXPLAIN option, SQL compiler 5-5
EXPLAIN report
execution plan 5-18
query decomposition 5-17
Explicit SQL compilation 1-7, 5-4
EXT option, SQLMEM directive 3-38
EXTDECS file 1-3, 3-22, 3-39, 4-1, 7-3
Extended data segment
estimating memory for 5-32
managing 3-42
specifying the default 3-38
EYE^CATCHER field in SQLDA,
initializing 6-18
, 7-6, 7-18
F
FASTSORT program 4-2, 4-8, 4-14
FETCH statement, SQL 3-34, 7-5
Fields in structures as host variables 2-8
File attributes, SQL
effect of altering 5-23
File label
SQL program file validation 5-22
File number
of SQLMSG file 4-3
, 4-15
FILEINFO command
FUP 5-22
SQLCI 5-22
FILEINQUIRE system procedure 4-1
FILES catalog tables
version 2 features D-8
File-system errors 2-4
displaying
with SQLCADISPLAY 4-2
with SQLCAFSCODE 4-7
with SQLCAGETINFOLIST 4-8
with SQLCATOBUFFER 4-13
First error flag
in SQLCAFSCODE procedure 4-8
FIXED TAL data type
in TYPE AS clause 2-7
with host variable 2-12
with SETSCALE SQL function 3-21
FOR UPDATE OF clause
UPDATE statement 3-45
FORCE option
error messages with 5-14
SQL compiler 5-8
FREE RESOURCES statement
and cursors 3-35
Functions, aggregate, SQL
for C10 program migration D-5
FUP
DUPLICATE command 5-22
FILEINFO command 5-22
G
Generic release program
description of D-12
GETPOOL system procedure 7-10, 7-17
Global area, user 3-38
GOTO format of WHENEVER 6-7