Re-executing a Query Statement String with Parameters (Embedded SQL Guide)

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

Once a query statement string with parameters is prepared, it can be used as often as required in an application. Before each subsequent use, the input XSQLDA can be supplied with new parameter and NULL indicator data. The cursor must be closed and reopened before processing can occur.

To provide new parameters to the input XSQLDA, follow steps 3–5 of Preparing a Query Statement String with Parameters (Embedded SQL Guide).

To provide new information to the output XSQLDA, follow steps 6–8 of Preparing a Query Statement String with Parameters (Embedded SQL Guide).

To reopen a cursor and process select-list items, repeat steps 2–4 of Executing a Query Statement String Within the Context of a Cursor (Embedded SQL Guide).