Adaptive Server 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.