On, Off

Off

The draft SQL/3 standard requires all cursors be closed when a transaction is rolled back. By default, on a rollback SQL 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.

• close_on_endtrans option
• Compatibility options
• ansi_close_cursors_on_rollback connection property
• Cursors and transactions