Ingres 11.2 | Open a Cursor

SQL Reference Guide > SQL Reference Guide > Working with Embedded SQL > Data Manipulation with Cursors > Open a Cursor

Was this helpful?

Open a Cursor

To open a cursor, use the OPEN statement:

EXEC SQL OPEN cursor_name [FOR READONLY];

Opening a cursor executes the associated SELECT statement. The rows returned by the SELECT statement are stored in a temporary result set. The cursor is positioned before the first row in the result table.

Note: If a cursor is closed and reopened, the cursor is repositioned to the beginning of the result table, and does not resume the position it had before it was closed.

Last modified date: 08/28/2024