Controls whether cursors that were opened WITH HOLD are closed when a ROLLBACK is performed.
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.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |