ASA Programming Guide
Using SQL in Applications
Adaptive Server Anywhere cursors
Both cursor sensitivity and transaction isolation levels address the problem of concurrency, but in different ways.
By choosing an isolation level for a transaction (often at the connection level), you determine when locks are placed on rows in the database. Locks prevent other transactions from accessing or modifying values in the database.
By choosing a cursor sensitivity, you determine which changes are visible to the application using the cursor. By setting cursor sensitivity you are not determining when locks are placed on rows in the database, and you do not limit the changes that can be made to the database itself.