SQL/MP Programming Manual for COBOL85

Contents
HP NonStop SQL/MP Programming Manual for COBOL85—429326-004
iii
4. Data Retrieval and Modification (continued)
4. Data Retrieval and Modification (continued)
DELETE Statement 4-10
Deleting a Single Row 4-11
Deleting Multiple Rows 4-11
Using SQL Cursors 4-11
Steps for Using a Cursor 4-12
Process Access ID (PAID) Requirements 4-13
Cursor Position 4-14
Cursor Stability 4-14
Virtual Sequential Block Buffering (VSBB) 4-14
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
SQLSADISPLAY 5-27
Superseded Procedures 5-30
SQLCADISPLAY 5-30