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.

See the Reference Manual: Commands and "Cursors: Accessing Data" in the Transact-SQL Users Guide.