https://sqlines.com/db2-to-oracle/cursor_with_hold
WITH HOLD Cursors - IBM DB2 to Oracle Migration - SQLines Tools
In DB2 you can use WITH HOLD clause in DECLARE CURSOR statement to specify that the cursor remains open when a COMMIT is issued. By default, DB2 closes a...
ibm db2 to oraclewith hold cursors