Read-only cursors

A cursor that cannot be updated can only be used for reading rows from the cursor table and is therefore referred to as a read-only cursor.

The diagram below indicates the SQL statements that can be used for a non-dynamic readonly 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”.