Transaction Support for Updatable Cursors

When select for update is set, SAP ASE supports fetch operations on open cursors after the transaction has been committed.

When you open a cursor, SAP ASE uses different locking mechanisms based on the transaction mode:
When you execute a commit between two fetch commands, or between closing and reopening a cursor, SAP ASE releases all exclusive locks. For subsequent fetch commands, SAP ASE acquires locks based on the transaction mode:
If update row locks are acquired, SAP ASE releases them only when:
Related concepts
Use select for update in Cursors and DML