You use STORE to save the current cursor position.
At the end of a transaction, all open cursors are closed. If you want to be able to access the contents of the derived table in the subsequent transaction, you must save the current cursor position with STORE before the end of the transaction. A cursor saved with STORE can be restored with the RESTORE statement.
FETCH cannot be used after STORE.
The cursor must be open.
STORE is not permitted if block mode is activated for the open cursor (see section "PREFETCH pragma").
STORE must not be used with cursors defined with WITH HOLD.
STORE cursor
cursor
Name of the cursor whose position is to be stored.
The call overwrites any cursor position for the same cursor previously saved with STORE.
See also
DECLARE CURSOR, OPEN, RESTORE