SQL Programming Manual for Pascal

Index
HP NonStop SQL Programming Manual for Pascal—528614-001
Index-9
T
SQLSA data structure (continued)
record description 6-10
SQLSADISPLAY procedure 4-22
SQLVAR structure, fields in 7-5
STOREDDEFINES option, SQL
compiler 5-8
Subqueries, result D-6
SUFFIX clause
with INVOKE 3-26
Swap file
for SQL compiler 5-13
SWAPVOL parameter, PARAM
command 5-14
SYSKEY
with INSERT statement 3-18
System procedures
FILEINQUIRE 4-1
MALLOC 7-14
T
Table
changes and program file validity 5-22
open time, automatic SQL
recompilation 5-24
version 2 D-8
TACL RUN command 3-2, 5-29, 5-30
Timestamp
check at table open time 5-25
inserting 3-21
program validation time 5-22
Transaction Monitoring Facility (TMF) 1-1,
7-12
TRANSIDS tables 5-10
Two-code thread design D-14
U
Uncompiled SQL statements, FORCE
option 5-15
Underscore (_)
in host variable names 2-2
UNTIL keyword in SQL statements 3-1
Update
multiple rows 3-37
single row 3-36
UPDATE statement 2-8, 3-9, 3-36
UPDATE STATISTICS statement
effects on program file validity 5-23
optimize execution plan 5-15
UPDATE WHERE CURRENT clause 7-35
Updating with null values 3-42
USAGES table 5-10
recorded program dependencies 5-11
unrecorded program
dependencies 5-15
USING DESCRIPTOR clause 7-34
V
VALID flag, SQL 5-22
Validation
program 5-21
with error conditions 5-15
VAR_PTR field
in SQLDA 7-6
Version control D-11
Version information
SQLGETCATALOGVERSION
procedure 4-19
SQLGETSYSTEMVERSION
procedure 4-21
Version issues
data types D-1
definitions D-1
features D-2
index D-2
programming techniques D-12
table D-2
view D-2
View
changes and program file validity 5-23