SQL/MP Programming Manual for COBOL

Contents
HP NonStop SQL/MP Programming Manual for COBOL—529758-003
iii
4. Data Retrieval and Modification (continued)
4. Data Retrieval and Modification (continued)
Updating a Single Row 4-9
Updating Multiple Rows 4-9
Updating Columns With Null Values 4-10
DELETE Statement 4-10
Deleting a Single Row 4-11
Deleting Multiple Rows 4-11
Using SQL Cursors 4-12
Steps for Using a Cursor 4-13
Access Requirements for Cursors 4-13
Cursor Position 4-14
Cursor Stability 4-14
Virtual Sequential Block Buffering (VSBB) 4-15
DECLARE CURSOR Statement 4-15
OPEN Statement 4-16
FETCH Statement 4-17
Multirow SELECT Statement 4-19
UPDATE Statement 4-20
Multirow DELETE Statement 4-22
CLOSE Statement 4-23
Using Foreign Cursors 4-23
5. SQL/MP System Procedures
COBOLEXT File 5-2
Guardian System Procedures 5-2
SQL Message File
5-2
SQLADDR
5-3
SQLCA_DISPLAY2_
5-4
Using SQLCA_DISPLAY2_ With an Error Table 5-7
Additional Considerations for SQLCA_DISPLAY2_ 5-7
Generating Meaningful Messages
5-11
SQLCA_TOBUFFER2_
5-11
Using SQLCA_TOBUFFER2_ With an Error Table 5-15
Additional Considerations for SQLCA_BUFFER2_
5-16
SQLCAFSCODE
5-17
SQLCAGETINFOLIST
5-17
SQLGETCATALOGVERSION
5-24
SQLGETOBJECTVERSION 5-25
SQLGETSYSTEMVERSION
5-26