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;