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 HCL OneDB™ Guide to SQL: Tutorial and the description of the SET TRANSACTION and SET ISOLATION statements in the HCL OneDB Guide to SQL: Syntax.