Contents Index Prefetching rows Describing result sets

ASA Programming Guide
  Using SQL in Applications
    Adaptive Server Anywhere cursors

Cursor sensitivity and isolation levels


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.


Contents Index Prefetching rows Describing result sets