Starting a Transaction with SNAPSHOT Isolation Level
Go Up to Isolation Level
InterBase assumes that the default isolation level for transactions is
SNAPSHOT need not be specified in
SET TRANSACTION to set the isolation level. For example, the following statements are equivalent. They both start a transaction,
READ WRITE access and set isolation level to
EXEC SQL SET TRANSACTION NAME t1; EXEC SQL SET TRANSACTION NAME t1 READ WRITE SNAPSHOT;
When an isolation level is specified, it must follow the access and lock resolution modes.