SQL Programming Manual for Pascal

Index
HP NonStop SQL Programming Manual for Pascal—528614-001
Index-8
S
Sequential I/O (SIO) procedures 4-2, 4-3,
4-8, 4-14, 4-22
Set operations
delete 3-12
update 3-39
SETSCALE function 2-4, 2-7, 3-23
Single row
delete 3-11
update 3-38
Single-code thread design D-12
SKIP UNAVAILABLE PARTITION option
CONTROL TABLE directive 5-29
Sort operations, using DEFINEs 5-32
SORTPROG process 4-2, 4-8, 4-14
Source file, Pascal compiler 5-2
SQL communication area
See SQLCA
SQL compilation
automatic recompilation 5-24
dynamic SQL statements 5-14
error messages 5-15
EXPLAIN utility 5-17
explicit 5-5
functions 5-11
listing 5-15
PARAM Command 5-13
SQLCOMP command 5-6
using DEFINEs 5-28
warning message 5-15
SQL component compatibility D-9
SQL directive 3-2, 3-35, 5-4, D-7
SQL sensitive 5-22
SQL statistics area
See SQLSA
SQLCA data structure 4-2
automatic SQL recompilation
errors 5-24
declaring 6-8
description of 6-8
SQLCADISPLAY procedure 2-4, 4-2, 6-9
SQLCAFSCODE procedure 4-7, 6-9
SQLCAGETINFOLIST error codes
(table) 4-10
SQLCAGETINFOLIST procedure 4-8, 6-9
SQLCATOBUFFER procedure 4-14, 6-9
SQLCI 1-1, 7-1
SQLCODE variable
after DELETE statement 3-11
automatic SQL recompilation
errors 5-24
checking 6-1
declaring 6-2
used by WHENEVER 6-4
SQLCOMP command 5-6
SQLDA data structure
additional fields for C30 D-6
data type literals 6-18
date-time range literals 6-19
describing parameters 2-13
EYE_CATCHER field 7-6
IND_PTR field 7-6
names buffer 6-14
NULL_INFO field 7-6
NUM_ENTRIES field 7-6
RELEASE1 template 6-14
RELEASE2 6-14
sample declarations C-7
VAR_PTR field 7-6
where to use 6-13
SQLGETCATALOGVERSION
procedure 4-19
SQLGETOBJECTVERSION
procedure 4-19
SQLGETSYSTEMVERSION
procedure 4-21
SQLMAP option, SQL directive 3-36
SQLMSG file 4-4, 4-6, 4-15, 4-17
SQLSA data structure
and SQLSADISPLAY 4-22
declaration 6-11
fields in 6-11