ASA Database Administration Guide
  Database Options
    Alphabetical list of options

CLOSE_ON_ENDTRANS option [compatibility]

Function 

Controls the closing of cursors at the end of a transaction.

Allowed values 

ON, OFF

Default 

ON

Description 

When CLOSE_ON_ENDTRANS is set to ON, cursors are closed whenever a transaction is committed unless the cursor was opened WITH HOLD. The behavior when a transaction is rolled back is governed by the ANSI_CLOSE_CURSORS_AT_ROLLBACK option.

When CLOSE_ON_ENDTRANS is set to OFF, cursors are not closed at either a commit or a rollback, regardless of the ANSI_CLOSE_CURSORS_AT_ROLLBACK option setting or whether the cursor was opened WITH HOLD or not.

Setting this to OFF provides Adaptive Server Enterprise compatible behavior.