HP NonStop SQL/MP

Contents
HP NonStop SQL/MP Programming Manual for C—429847-008
iii
4. Data Retrieval and Modification (continued)
4. Data Retrieval and Modification (continued)
Updating Multiple Rows 4-12
Updating Columns With Null Values 4-12
DELETE Statement 4-12
Deleting a Single Row 4-13
Deleting Multiple Rows 4-13
Using SQL Cursors 4-14
Steps for Using a Cursor 4-15
Process Access ID (PAID) Requirements 4-16
Cursor Position 4-16
Cursor Stability 4-17
Virtual Sequential Block Buffering (VSBB) 4-17
DECLARE CURSOR Statement 4-18
OPEN Statement 4-19
FETCH Statement 4-20
Multirow SELECT Statement 4-21
UPDATE Statement 4-22
Multirow DELETE Statement 4-23
CLOSE Statement 4-24
Using Foreign Cursors 4-24
5. SQL/MP System Procedures
Guardian System Procedures 5-2
cextdecs Header File 5-2
SQL Message File 5-2
SQLCADISPLAY
5-3
SQLCAFSCODE
5-8
SQLCAGETINFOLIST
5-9
SQLCATOBUFFER 5-14
SQLGETCATALOGVERSION 5-18
SQLGETOBJECTVERSION
5-19
SQLGETSYSTEMVERSION
5-19
SQLSADISPLAY 5-20
6. Explicit Program Compilation
Explicit Program Compilation 6-1
Developing a C Program in the Guardian Environment
6-5
Using TACL DEFINEs in the Guardian Environment
6-6
Specifying the SQL Pragma in the Guardian Environment 6-7