Cursors WITH HOLD

Informix® automatically closes opened cursors when a transaction ends unless the WITH HOLD option is used in the DECLARE instruction.

Sybase ASE does not close cursors when a transaction ends, as long as the global parameter close_on_endtrans is off.

Solution

BDL cursors that are not declared "WITH HOLD" are automatically closed by the database interface when a COMMIT WORK or ROLLBACK WORK is performed by the BDL program.