Adaptive Server extends the declare cursor syntax to include the release_locks_on_close option, which releases shared cursor locks at isolation levels 2 and 3 when a cursor is closed. Adaptive Server ODBC Driver accordingly supports the release-lock-on-close semantics.
To apply this functionality to all read-only cursors created on an Adaptive Server ODBC Driver connection, set the ReleaseLocksOnCursorClose connection property to 1. The default ReleaseLocksOnCursorClose value is 0.
Settings applied through the ReleaseLocksOnCursorClose connection property is static and cannot be changed after the connection has been established. This setting takes effect only when connected to a server that supports release_locks_on_close.
For information about release_locks_on_close, see the Adaptive Server Enterprise Reference Manual: Commands.
