Try OpenEdge Now
skip to main content
SQL Development
Data Control Language and Transaction Behavior : Transactions and isolation levels
 

Transactions and isolation levels

SQL defines how a database is expected to behave in different situations. These situations are defined as transaction isolation levels. The isolation levels are defined by possible phenomena that might exist in the database at the four possible levels. Before you can understand isolation levels, you must first understand what these phenomena are.
The following phenomena are used to define isolation levels.
* Dirty read
* Nonrepeatable read
* Phantom read
* Setting isolation levels