ASA Database Administration Guide
  Database Options
    Alphabetical list of options

ANSI_CLOSE_CURSORS_ON_ROLLBACK option [compatibility]

Function 

Controls whether cursors that were opened WITH HOLD are closed when a ROLLBACK is performed.

Allowed values 

ON, OFF

Default 

OFF

Description 

The draft SQL/3 standard requires all cursors be closed when a transaction is rolled back. By default, on a rollback Adaptive Server Anywhere closes only those cursors that were opened without a WITH HOLD clause. This option allows you to force closure of all cursors.

The CLOSE_ON_ENDTRANS option overrides the ANSI_CLOSE_CURSORS_ON_ROLLBACK option.