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.
- Tip: It is good programming practice to specify an isolation level of a transaction, even when it is
SNAPSHOT. It makes a source code of an application easier to read and debug because the intentions of the program are clearly spelled out.