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 non-ANSI-compliant databases that do not use transaction logging is Uncommitted Read. For information about isolation levels, see the Informix® Guide to SQL: Tutorial and the description of the SET TRANSACTION and SET ISOLATION statements in the Informix Guide to SQL: Syntax.