SQL/MP Programming Manual for COBOL85

Index
HP NonStop SQL/MP Programming Manual for COBOL85—429326-004
Index-15
V
UPDATE statement
description 3-5, 4-8
indicator variables 2-10
multiple rows 4-9
null value 4-10
single-row 4-9
SQLCODE values 4-8
with a cursor 4-1, 4-20
without a cursor 4-1
UPDATE STATISTICS statement 3-5, 6-33
UPDATE WHERE CURRENT clause, with
cursors 10-32
USAGE clause, host variable
declaration 2-9
USER-LINE-NUMBER, SQLCA structure
field 9-12
USING DESCRIPTOR clause, with
cursors 10-31
V
VALID flag, program file label 8-1
Valid SQL program 8-1
Validation functions, of SQL compiler 8-1
VALUE clause, host variable
declaration 2-9
VARCHAR data type
description 2-25
with INVOKE directive 2-17
Variables, environment, OSS 6-17
VAR-PTR, SQLDA structure field 10-13
Version information
displaying with SQL
GETOBJECTVERSION 5-25
displaying with
SQLGETSYSTEMVERSION 5-24,
5-26
GET VERSION OF PROGRAM 6-44,
7-7
GET VERSION OF SYSTEM 7-6
SQL/MP system procedures 5-1
Version management
COBOL85 compiler 6-43, 9-2
converting COBOL programs D-1
INCLUDE STRUCTURES directive 9-1
similarity check 8-11
SQL compiler 6-43
SQL components 6-43
SQL data structures D-1
SQL program file 6-44
SQL/MP 1-7
VPROC program 9-2
Version number
of SQL objects 1-7
of SQL/MP releases 1-7
VERSION, SQLSA structure field 9-22
VERSION-ID, SQLCA structure field 9-12
Virtual Sequential Block Buffering
(VSBB) 4-14
VPROC program 6-43, 9-2
VSBB (Virtual Sequential Block
Buffering) 4-14
W
WAITS, SQLSA structure field 9-23
Warning messages
detection 9-6
displaying with system procedures 9-11
SQL compiler 6-34
WHENEVER directive
description 9-6
determining scope 9-7
enabling and disabling 9-8
error checking 9-6
WHERE clause
DELETE statement 4-11
indicator variable 2-12
SELECT statement 4-12
WHERE CURRENT OF clause
DELETE statement 4-22
UPDATE statement 4-20