HP NonStop SQL/MP - Page 330

Index
HP NonStop SQL/MP Programming Manual for C—429847-008
Index-18
V
UPDATE STATISTICS statement
effect on program invalidation 8-3
effect on SQL validity 8-3
error 8204 4-3
maximizing local autonomy C-2
RECOMPILE option, program
invalidation 8-5
UPDATE STATISTICS statement, SQL
compiler 6-21
UPDATE WHERE CURRENT clause for a
cursor 10-21
USAGES table
CHECK INOPERABLE PLANS
option 8-5
SQL compiler access 6-13
SQL compiler entries 8-1
unrecorded program
dependencies 6-23
USER option, SQLMEM pragma B-2
USING DESCRIPTOR clause
FETCH statement 10-12
for a cursor 10-21
V
VALID flag, SQL
checking 8-1
PROGRAMS table 8-4
Validation, program file
checking 8-1
Validation, program file, FORCE
option 6-23
VARCHAR data type
correspondence in C 2-3, 2-4
host variable declaration 2-9
Variable-length character data, host
variable declaration 2-9
VERIFIEDWRITES attribute, similarity
check rules 8-12
VERIFY utility, SQL 8-1
Version management
C compiler 6-36, 9-3
Version management (continued)
description 1-7
displaying information
SQLGETCATALOGVERSION
procedure 5-18
SQLGETOBJECTVERSION
procedure 5-19
SQLGETSYSTEMVERSION
procedure 5-19
INCLUDE STRUCTURES directive 9-1
SQL compiler 6-36
SQL Executor 7-7
SQL program file 6-37
VPROC program 9-3
vi text editor 6-28
View, SQL
changes and program file validity 8-3
declaring record descriptions 2-19
Virtual sequential block buffering (VSBB),
SQL cursor operations 4-17
VPROC program 9-3
W
Warning messages
detecting with WHENEVER
directive 9-6
Warning messages, SQL compiler 6-23
WHENEVER directive
description 9-6
disabling checking 9-7
dynamic SQL 10-23
enabling checking 9-7
scope 9-7
WHENEVERLIST option, SQL pragma 6-7
WHERE CURRENT OF clause, UPDATE
statement 4-22
WRITEREAD procedure 1-4