Adaptive Server default isolation level

Adaptive Server’s default isolation level is 1, which prevents dirty reads. Adaptive Server enforces isolation level 1 by:

Using exclusive and shared locks allows Adaptive Server to maintain the consistency of the results at isolation level 1. Releasing the shared lock after the scan moves off a page improves Adaptive Server concurrency by allowing other transactions to obtain their exclusive locks on the data.