SQL-J Language Reference
Page 7 of 121

AT ISOLATION clause

Allows a user to specify an isolation level for a SELECT statement without committing the current transaction. This clause changes the isolation level for the current statement only, not the transaction.

The other ways of changing the isolation level for a connection, JDBC method calls and the SET TRANSACTION ISOLATION LEVEL statement, commit the current transaction.

For information about isolation levels, see Locking, Concurrency, and Isolation in the Cloudscape Developer's Guide.

NEW: Support for REPEATABLE_READ is new in Version 3.6.

Syntax

AT ISOLATION {
    READ COMMITTED |
    SERIALIZABLE |
    REPEATABLE READ
}

AT ISOLATION clause Examples

-- set the isolation level to SERIALIZABLE for this
-- statement only
SELECT *
FROM Flights
WHERE flight_id BETWEEN 'AA1111' AND 'AA1112'
AT ISOLATION SERIALIZABLE