Updatable cursors

An updatable cursor can be used to delete or update rows in a table in addition to reading rows.

The diagram below indicates the SQL statements that can be used for a non-dynamic updatable cursor and the order in which they are used:

RESTORE can only be used to open a cursor after a STORE statement. If a cursor position has been stored, FETCH cannot be used.

Other statements that can be used with dynamic cursors are described in the section "Dynamic cursor descriptions".