SET TRANSACTION statements take effect at the beginning of a transaction, and they affect the transaction until the transaction is committed or rolled back. If the SET TRANSACTION statement is executed in the middle of a transaction, an error is returned.
The SET TRANSACTION statement 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;