SQL Guide : solidDB® SQL statements : SET TRANSACTION
  
SET TRANSACTION
The SET TRANSACTION commands have effect in the beginning of a transaction, and they affect the transaction until commit or abort. If the SET TRANSACTION statement is issued in the middle of a transaction, an error is returned.
The SET TRANSACTION command is based on ANSI SQL. However, the solidDB® implementation has some differences from the ANSI definition. solidDB® does not support combining two ANSI-defined transaction properties in one SET TRANSACTION statement, for example: SET TRANSACTION ISOLATION LEVEL SERIALIZABLE, READ WRITE;
However, solidDB® supports multiple SET TRANSACTION statements in a single transaction, for example:
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; SET TRANSACTION READ WRITE;
Examples
SET TRANSACTION DURABILITY RELAXED;
SET TRANSACTION ISOLATION REPEATABLE READ;
SET TRANSACTION READ WRITE;
See
Differences between SET and SET TRANSACTION
SET TRANSACTION (read/write level)
SET TRANSACTION DURABILITY
SET TRANSACTION ISOLATION LEVEL
SET TRANSACTION SAFENESS
See also
solidDB® SQL statements