| SQL adaptation guide For SQL SERVER 2005, 2008, 2012 / BDL programming | |
Informix® automatically closes opened cursors when a transaction ends unless the WITH HOLD option is used in the DECLARE instruction.
Microsoft™ SQL SERVER does not close cursors when a transaction ends. You can change this behavior using the SET CURSOR_CLOSE_ON_COMMIT ON.
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.