Adaptive Server version 11.9.2 provides new commands and options that affect locking:
readpast option
lock table command
Server-level and session level options that specify how long tasks wait for locks
Support for repeatable reads transaction isolation level (level 2) for data-only-locked tables
