SQL Programming Manual for TAL
Index
HP NonStop SQL Programming Manual for TAL—527887-001
Index-12
S
SORTPROG process 4-2, 4-8, 4-14
SORT_DEFAULTS DEFINE
See=_SORT_DEFAULTS DEFINE
Source file, TAL compiler 5-2
SQL compilation
automatic recompilation 5-24
explicit 1-7
functions of SQL compiler 5-11
insufficient information for 5-15
interpreting error messages 5-14
listing 5-15
of dynamic SQL statements 5-14
SQL compiler 1-7
unresolved TACL DEFINEs for 5-15
using a PARAM command 5-13
using DEFINEs with 5-32
using EXPLAIN utility with 5-17
warning messages for 5-14
with SQLCOMP command 5-6
SQL directive, TAL compiler 3-1, 3-2, 3-35
SQL SENSITIVE flag 5-22
SQL SENSITIVE, SQL 5-22
SQL statements
See NonStop SQL statements 1-1
SQL statistics area
See SQLSA data structure
SQLCA data structure 4-7
, 4-8, 4-14
after DELETE statement 3-13
after INSERT statement 3-20
automatic SQL recompilation
errors 5-24
declaring 6-9
description of 6-9
displaying with SQLCADISPLAY 4-2
with UPDATE statement 3-42
SQLCADISPLAY system procedure 1-4,
2-4
, 4-2, 6-9
SQLCAFSCODE system procedure 4-7,
6-9
SQLCAGETINFOLIST system
procedure 6-9
SQLCATOBUFFER system
procedure 4-13
, 6-9
SQLCI
See Conversational interface, NonStop
SQL
SQLCODE variable
after DELETE statement 3-13
after FETCH statement 3-18
after INSERT statement 3-20
after UPDATE statement 3-43
checking 6-2
declaring 6-2
declaring for dynamic SQL 7-9
in data conversion 2-4
used by WHENEVER 6-4
with automatic SQL recompilation
errors 5-24
SQLCOMP command 5-24
SQLDA data structure 6-13, 7-6
data type literals for 6-18
EYE^CATCHER field 6-18
fields in 6-17
names buffer 6-14
Release 1 template 6-15
Release 2 template 6-15
SQLDA^EYE^CATCHER literal 7-10, 7-11,
7-18
SQLGETCATALOGVERSION system
procedure 4-19
, D-11
SQLGETOBJECTVERSION system
procedure 4-19
, D-11
SQLGETSYSTEMVERSION system
procedure 4-21
, D-11
SQLIN data structure 3-37
SQLIVARS data structure 3-37
SQLMAP option, SQL directive 3-37
SQLMEM directive, TAL compiler 3-1, 3-38
SQLMSG
file number 4-3
SQLMSG file
description of 4-6
, 4-18