SQL/MX 3.2 Programming Manual for C and COBOL (H06.25+, J06.14+)

Contents
HP NonStop SQL/MX Release 3.2 Programming Manual for C and COBOL—663854-002
viii
12. Dynamic SQL Rowsets
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
13. Exception Handling and Error Conditions
Checking the SQLSTATE Variable 13-1
Declaring SQLSTATE 13-2
SQL:1999 SQLSTATE Values 13-2
SQL/MX SQLSTATE Values 13-3
Using SQLSTATE 13-4
Checking the SQLCODE Variable 13-5
Declaring SQLCODE 13-5
Declaring SQLCODE and SQLSTATE 13-5
SQLCODE Values
13-10
Using SQLCODE
13-10
SQL/MX Exception Condition Messages
13-11
Viewing the SQL Messages 13-12
Accessing SQL Messages Within a Program
13-12
Using the WHENEVER Statement
13-13
Precedence of Multiple WHENEVER Declarations
13-14
Determining the Scope of a WHENEVER Declaration 13-14
Enabling and Disabling the WHENEVER Declaration 13-14
Saving and Restoring SQLSTATE or SQLCODE 13-15
Declaring SQLSTATE or SQLCODE in an Error Routine 13-16
Accessing and Using the Diagnostics Area 13-17
Using the GET DIAGNOSTICS Statement
13-18
Getting Statement and Condition Items
13-18
Special SQL/MX Error Conditions 13-20
Lost Open Error (8574) 13-20