Adaptive Server 15.7 and later supports select for update, which can
lock rows for subsequent updates within the same transaction, and supports exclusive locks
for updatable cursors.
See Queries: Selecting Data from a Table in the Adaptive Server
Enterprise Transact-SQL Users Guide.
This functionality is automatically available to clients when
the for update clause is added to a select statement
and to any updatable cursors opened within the clients.