Was this helpful?
Summary of Cursor Positioning
The following list summarizes the effects of cursor statements on cursor positioning:
open cursor
Specifies that the cursor positioned before first row in set
retrieve cursor
Specifies that the cursor moves to next row in set. If already on last row, cursor moves beyond the set and its position becomes undefined.
replace cursor
Specifies that the cursor remains on current row
delete cursor
Specifies that the cursor moves to a position after the deleted row (but before the following row)
close cursor
Specifies that the cursor and set of rows become undefined
For more information about cursors, see the Embedded QUEL Companion Guide.
Last modified date: 01/30/2023