solidDB Help : solidDB reference : SQL: Statements : SET TRANSACTION
  
SET TRANSACTION
Note For information about the differences between the SET and the SET TRANSACTION statements, see Differences between SET and SET TRANSACTION.
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;
See
SET TRANSACTION (read/write level)
SET TRANSACTION [DELETE] CAPTURE
SET TRANSACTION DURABILITY
SET TRANSACTION ISOLATION LEVEL
SET TRANSACTION SAFENESS
SET TRANSACTION TRIGGERS
Go up to
SQL: Statements