Re-executing the Statement String (Embedded SQL Guide)

Go Up to Method 2: Non-query Statements with Parameters (Embedded SQL Guide)

Once a non-query statement string with parameters is prepared, it can be executed as often as required in an application. Before each subsequent execution, the input XSQLDA can be supplied with new parameter and NULL indicator data.

To supply new parameter and NULL indicator data for a prepared statement, repeat steps 3–5 of Preparing and Executing a Statement String with Parameters (Embedded_SQL_Guide), in this chapter.