SQL Programming Manual for TAL

Index
HP NonStop SQL Programming Manual for TAL—527887-001
Index-15
U
U
Uncompiled SQL statements, FORCE
option 5-14
Underscore (_)
in host variable names 2-2
UNTIL TAL keyword in SQL
statements 1-2
, 3-1
Update operation
multiple rows 3-14
set of rows 3-14
single row 3-14
using indicator parameter in 2-23
using null values in 2-17
with null values 3-47
UPDATE statement, SQL 3-42
Update statistics
effect on SQL validity 5-23
optimized execution plan 5-14
UPDATE STATISTICS statement,
SQL 5-11
, 5-14, 5-23
UPDATE WHERE CURRENT clause
for a cursor 7-32
USAGES table 5-11
recorded program dependencies 5-23
unrecorded program
dependencies 5-15
Usages table 5-10
USER option, SQLMEM directive 3-38
USESEGMENT system procedure 3-38
USING DESCRIPTOR clause
for a cursor 7-32
in FETCH statement 7-5
V
VALID flag, SQL 5-22
Validation
program file 5-22
with error conditions 5-14
VARCHAR data type
as host variable 2-8
VARCHAR data type
columns with INVOKE directive 3-24
VAR^PTR field
in SQLDA structure 7-5
VERIFY utility, SQL 5-22
Version information
data types D-1
descriptions D-2
features D-1
functions D-1
using
SQLGETCATALOGVERSION 4-19
,
D-2
, D-11
using
SQLGETOBJECTVERSION 4-19
, D-2,
D-11
using
SQLGETSYSTEMVERSION 4-21
, D-2,
D-11
, D-13
versioning PVU D-9
Version Management, NonStop SQL A-2
VERSIONS catalog table D-12
View, SQL
changes and program file validity 5-23
version 2 D-2
W
Warning messages
detecting with WHENEVER 6-4
for SQL compiler 5-14
WHENEVER directive, SQL 6-4, B-11
WHENEVERLIST option, SQL
directive 3-36
WHERE clause
in subquery for C10 program
migration D-6
WHERE CURRENT OF
in DELETE statement 3-15
WHERE CURRENT OF clause
in DELETE statement 3-15
in UPDATE statement 3-45