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.