SQL/MX 3.2.1 Programming Manual for C and COBOL (H06.26+, J06.15+)

Contents
HP NonStop SQL/MX Release 3.2.1 Programming Manual for C and COBOL—663854-005
v
7. Static Rowsets
Declare Required Host Variables 6-4
Declare the Cursor 6-4
Initialize the Host Variables 6-5
Open the Cursor 6-5
Retrieve the Values 6-6
Process the Retrieved Values 6-7
Fetch the Next Row 6-10
Close the Cursor 6-11
Using Date-Time and INTERVAL Data Types 6-12
Standard Date-Time Example 6-12
Nonstandard SQL/MP DATETIME Example 6-13
Interval Example 6-13
Using Floating-Point Data Types 6-14
Considerations When Using a Cursor 6-14
Cursor Position 6-15
Cursor Stability 6-15
Cursor Sensitivity 6-16
7. Static Rowsets
What Are Rowsets? 7-1
Using Rowsets 7-2
Declaring Host Variable Arrays as Rowsets 7-2
Rowset Host Variable Pointers 7-3
Considerations for Rowset Size 7-4
Specifying Rowset Arrays 7-4
Using Rowset Arrays for Input
7-6
Using Rowset Arrays for Output
7-6
Using Rowset Arrays in DML Statements
7-7
Selecting Rows Into Rowset Arrays 7-7
Selecting Rowsets With a Cursor 7-16
Inserting Rows From Rowset Arrays
7-18
Updating Rows by Using Rowset Arrays
7-21
Deleting Rows by Using Rowset Arrays 7-23
Specifying Size and Row ID for Rowset Arrays
7-24
Limiting the Size of the Input Rowset
7-26
Limiting the Size of the Input Rowset When Declaring a Cursor
7-27
Limiting the Size of the Output Rowset
7-28
Using the Index Identifier 7-29
Specifying Rowset-Derived Tables
7-32