Method 3: Query Statements Without Parameters (Embedded SQL Guide)

Go Up to DSQL Programming Methods (Embedded SQL Guide)

There are three steps to processing a SQL query statement string without parameters:

1. Preparing an output XSQLDA to process the select-list items returned when the query is executed.
2. Preparing the statement string.
3. Using a cursor to execute the statement and retrieve select-list items from the output XSQLDA.

Topics

• Preparing the Output XSQLDA to Query Statements Without Parameters
• Preparing a Query Statement String
• Executing a Statement String Within the Context of a Cursor
• Re-executing a Query Statement String