| SQL adaptation guide for SAP Sybase ASE 16.x / BDL programming | |
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.
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.