Adaptive Server 15.7 supports select for update, which can lock rows for subsequent updates within the same transaction, and supports exclusive locks for updatable cursors. See Chapter 2, "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.
