5. Embedded QUEL : Data Manipulation with Cursors : Retrieving the Data
 
Share this page                  
Retrieving the Data
The retrieve cursor statement reads the next row of data (as specified in the declare statement) into the specified host variables. The syntax is:
## retrieve cursor cursor_name (variable {variable})
To detect the end of a table, use the inquire_ingres statement to determine the endquery status. For details about inquire_ingres, see Inquire_ingres Statement—Get Diagnostic Information.
The retrieve cursor statement is typically used within a program loop to processes a series of rows; using cursors you can only move forward through rows (or reposition to the top of the table by closing and reopening the cursor).