Re-executing a Query Statement String
Go Up to Method 3: Query Statements Without Parameters (Embedded SQL Guide)
Once a query statement string without parameters is prepared, it can be executed as often as required in an application by closing and reopening its cursor.
To reopen a cursor and process select-list items, repeat steps 2–4 of Executing a Statement String Within the Context of a Cursor (Embedded_SQL_Guide).