Method 3: Query Statements Without Parameters

Go Up to DSQL Programming Methods

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

1. Prepare an output XSQLDA to process the select-list items returned when the query is executed.
2. Prepare the statement string.
3. Use 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 Without Parameters
• Executing a Statement String Within the Context of a Cursor
• Re-executing a Query Statement String Without Parameters