Ingres 12.0 | RETRIEVE CURSOR--Retrieve Data into Host Variables

QUEL Reference Guide > QUEL Reference Guide > QUEL and EQUEL Statements > RETRIEVE CURSOR--Retrieve Data into Host Variables

Was this helpful?

RETRIEVE CURSOR--Retrieve Data into Host Variables

Valid in: EQUEL

Retrieves data into host variables using a cursor.

This statement has the following format:

## retrieve cursor cursor_name (variable)
## {, variable})

The retrieve cursor statement advances the cursor one row and loads the values specified in the retrieve clause of the declare cursor statement into the specified host variables. The retrieve cursor statement is the only way to advance a cursor.

Last modified date: 08/28/2024