Enterprise Edition Home | Express Edition Home | Previous Page | Next Page   SQL Statements > SET TRANSACTION >

Default Isolation Levels

The default isolation level is established when you create the database.

Informix Name ANSI Name When This Is the Default Level of Isolation
Dirty Read Read Uncommitted Database without transaction logging
Committed Read Read Committed Databases with logging that are not ANSI- compliant
Repeatable Read Serializable ANSI-compliant databases

The default isolation level remains in effect until you issue a SET TRANSACTION statement within a transaction. After a COMMIT WORK statement completes the transaction or a ROLLBACK WORK statement cancels the transaction, the isolation level is reset to the default.

Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]