Actian X 11.2 | Using Cursors to Update Data

QUEL Reference Guide > QUEL Reference Guide > Embedded QUEL > Data Manipulation with Cursors > Using Cursors to Update Data

Was this helpful?

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.

Last modified date: 04/03/2024