Default isolation level

The database isolation level specifies the degree to which your program is isolated from the concurrent actions of other programs. The default isolation level for all ANSI-compliant databases is Repeatable Read. The default isolation level for non-ANSI-compliant databases that support transaction logging is Committed Read. The default isolation level for unlogged databases is Uncommitted Read. You cannot change the default isolation level or the current isolation level of an unlogged database. For information about isolation levels, see the HCL® Informix® Guide to SQL: Tutorial and the description of the SET TRANSACTION and SET ISOLATION statements in the HCL® Informix® Guide to SQL: Syntax.