You can group SQL statements into transactions, which have the property that either all statements are executed or none is executed. You should design each transaction to perform a task that changes your database from one consistent state to another.
This chapter describes transactions and how to use them in applications. It also describes how Adaptive Server Anywhere you can set isolation levels to limit the interference among concurrent transaction.
Introduction to transactions
Isolation levels and consistency
Transaction blocking and deadlock
Choosing isolation levels
Isolation level tutorials
How locking works
Particular concurrency issues
Replication and concurrency
Summary