SET ISOLATION

Change the transaction isolation level for the connection.

Syntax

SET [ CURRENT ] ISOLATION [ = ]
{ 
UR | DIRTY READ | READ UNCOMMITTED 
CS | READ COMMITTED | CURSOR STABILITY
RESET
}

Description

The supported isolation levels in SQLFire are NONE, READ COMMITTED, and READ UNCOMMITTED. The READ UNCOMMITTED level is implicitly upgraded to READ COMMITTED.

Isolation level NONE indicates no transactional behavior. The RESET clause corresponds to the NONE isolation level.

Understanding the Data Consistency Model and Using Distributed Transactions in Your Applications provide details about non-transactional and transactional behavior in SQLFire.

This statement behaves identically to the JDBC java.sql.Connection.setTransactionIsolation method and commits the current transaction if isolation level has changed.

Example

sqlf(PEERCLIENT)> set ISOLATION READ COMMITTED;
0 rows inserted/updated/deleted
sqlf(PEERCLIENT)> VALUES CURRENT ISOLATION;
1
----
CS

1 row selected