Storing a cursor

If you want to retain the cursor table and the cursor position beyond the end of the current transaction, you can save the cursor with the STORE statement. Please note, however, that between STORE and the subsequent closure of the cursor, the cursor table can no longer be read with FETCH. STORE is not permitted for local cursors (in routines).

Another simpler option for keeping a cursor open across several transactions is to use the WITH HOLD clause in the cursor definition. The WITH HOLD clause is not permitted for local cursors (in routines).