5. Embedded QUEL : Data Manipulation with Cursors : Using Cursors to Update Data
 
Share this page                  
Using Cursors to Update Data
To update fields that were retrieved using a cursor, use the replace cursor statement:
## replace cursor cursor_name (column expression
    {, column = expression})
The replace cursor statement causes no change in the position of the cursor. A retrieve cursor is required to move the cursor forward one row. If you try to replace the same row twice (without advancing the cursor) and the cursor was opened in deferred mode, the DBMS Server issues a runtime error.
The update affects only the current row, and you can only update columns that were declared in the for...update clause of the declare cursor statement. For details, see Declaring a Cursor.