Method 4: Query Statements with Parameters (Embedded SQL Guide)

Go Up to DSQL Programming Methods (Embedded SQL Guide)

To process a SQL query statement string with placeholder parameters, there are four steps to follow:

1. Preparing an input XSQLDA to process the parameters of a statement string.
2. Preparing an output XSQLDA to process the select-list items returned when the query is executed.
3. Preparing the statement string and its parameters.
4. Using a cursor to execute the statement using input parameter values from an input XSQLDA, and to retrieve select-list items from the output XSQLDA.

Topics

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