Changes to Cursors

Adaptive Server version 15.7 includes changes to cursor locks, how cursors manage transactions, and how it declares cursor statements.

• Release Cursor Locks at Cursor Close
  Adaptive Server 15.7 includes the declare cursor ... release_locks_on_close option to release cursor locks at isolation levels 2 and 3 when the cursor is closed, even if the transaction is active.
• Enhanced Transaction Support for Cursors
  Adaptive Server 15.7 and later changes the way cursors support transactions:
• Monitor Cursor Statements
  Adaptive Server version 15.7 monitors cursor statements based information from the monCachedStatement monitoring table.