Starting a transaction with SNAPSHOT TABLE STABILITY isolation level
From InterBase
Go Up to Isolation Level
To start a SNAPSHOT TABLE STABILITY transaction, the isolation level must be specified. For example, the following statement starts a named transaction, t1, for READ WRITE access and sets isolation level to SNAPSHOT TABLE STABILITY:
EXEC SQL SET TRANSACTION NAME t1 READ WRITE SNAPSHOT TABLE STABILITY;
Isolation level always follows the optional access mode and lock resolution parameters, if they are present.
Important:
Use
Use
SNAPSHOT TABLE STABILITY with care. In an environment where multiple transactions share database access, SNAPSHOT TABLE STABILITY greatly increases the likelihood of lock conflicts.