solidDB Help : solidDB reference : SQL: Statements : SET : SET (read/write level)
  
SET (read/write level)
SET {READ WRITE | READ ONLY | WRITE}
Access requirements
Database user
Usage
Use this SET statement to specify which of the following types of operation the connection can execute.
This statement takes effect from the next transaction (that is, after the next COMMIT WORK statement).
Parameters, clauses, keywords, and variables
▪ READ WRITE (default): Connection can execute both read and write operations.
▪ READ ONLY: Connection can execute only read operations.
▪ 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, see Load balancing in Transparent Connectivity.
See also, SET ISOLATION LEVEL.
Example
SET READ ONLY;
Go up to
SET