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. See Adaptive Server Enterprise ODBC Driver Users Guide and jConnect for JDBC Programmers Reference for information about creating updatable cursors.