Advanced PowerBuilder

Isolation Levels

Watcom supports isolation levels with the OPEN <cursor name> statement, but PowerBuilder doesn't support it. The isolation level specifies the kind of actions that are not permitted while the current transaction executes. The ANSI standard defines three levels of isolation for the SQL transactions:

• Level 1 prevents dirty reads.
• Level 2 prevents non-repeatable reads.
• Level 3 prevents both types of reads and phantoms.