solidDB Help : solidDB reference : SQL: Statements : SET TRANSACTION : SET TRANSACTION (read/write level)
  
SET TRANSACTION (read/write level)
SET TRANSACTION {READ WRITE | READ ONLY | WRITE}
Access requirements
Database user
Usage
Use the SET TRANSACTION statement to specify whether a transaction is allowed to make any changes to data.
The statement is based on the ANSI SQL SET TRANSACTION statement, which has only READ WRITE and READ ONLY options. In solidDB, the additional option WRITE is available.
READ WRITE: (default) The transaction can read and write data.
READ ONLY: The transaction can only read data.
WRITE: This option can be used in a HotStandBy (HSB) configuration to change the workload connection server from the secondary server to the primary server for one transaction, see Load balancing in Transparent Connectivity.
Example
SET TRANSACTION READ WRITE;
Go up to
SET TRANSACTION