SQL/MX Programming Manual for C and COBOL (G06.24+, H06.03+)

Contents
HP NonStop SQL/MX Programming Manual for C and COBOL—523627-004
viii
10. Dynamic SQL With Descriptor
Areas (continued)
10. Dynamic SQL With Descriptor Areas (continued)
Using SQL Descriptor Areas to Select SQL/MP KANJI and KSC5601 Data 10-21
Using SQL Descriptor Areas to Retrieve ISO88591 Data to UCS2 Host
Variables 10-21
11. Dynamic SQL Cursors
Statements for Dynamic SQL Cursors 11-1
Steps for Using a Dynamic SQL Cursor 11-2
Declare Required Host Variables 11-4
Prepare the Cursor Specification 11-4
Declare the Cursor 11-4
Initialize the Dynamic Input Parameters 11-5
Open the Cursor 11-5
Retrieve the Values 11-5
Process the Retrieved Values 11-6
Fetch the Next Row 11-6
Close the Cursor and Deallocate the Prepared Statement 11-6
Using Date-Time and INTERVAL Data Types 11-7
Standard Date-Time Example 11-7
Interval Example 11-8
Nonstandard SQL/MP DATETIME Example 11-9
Dynamic SQL Cursors Using Descriptor Areas 11-10
12. Dynamic SQL Rowsets
Using Dynamic SQL Rowsets 12-1
Preparing an SQL Statement With Dynamic Rowsets 12-2
Specification of an Rowset Parameter in the PREPARE String
12-3
Matching Compile-Time Specified Length With Execution-Time Length
12-4
Dynamic SQL With Argument Lists 12-5
Using the SET DESCRIPTOR Statement 12-5
Setting the Rowset-Specific Descriptor Fields 12-5
Exclusive Use of VARIABLE_POINTER and INDICATOR_POINTER 12-9
Using the GET DESCRIPTOR Statement 12-9
Using the DESCRIBE INPUT Statement 12-10