Method 4: Query Statements With Parameters

Go Up to DSQL Programming Methods

There are four steps to processing a SQL query statement string with placeholder parameters:

1. Prepare an input XSQLDA to process a statement string’s parameters.
2. Prepare an output XSQLDA to process the select-list items returned when the query is executed.
3. Prepare the statement string and its parameters.
4. Use 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