SQL/MP Programming Manual for C

Contents

HP NonStop SQL/MP Programming Manual for C—429847-008

iii

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