What Are The Informix Isolation Levels?
- DIRTY READ: Dirty Read Reads the data without checking whether the data is committed or not. During the read, no locks are held.
- COMMITTED READ: Committed Read reads only the determined data. During the read, no locks are held.
- REPEATABLE READ: Reads only the committed data. In this read, a shared lock is held on the rows. Other sessions can get the shared locks on those rows, but no one can get an exclusive lock.
- CURSOR STABILITY