Defining read-only and read-write transactions

SQL Guide : Managing transactions : Defining read-only and read-write transactions

To define a transaction to be read-only or read-write, use the following SQL commands:

SET TRANSACTION { READ ONLY | READ WRITE }

The following options are available with this command.

▪READ ONLY

Use this option for a read only transaction.

▪READ WRITE

Use this option for a read and write transaction. This option is the default.

Note To detect conflicts between transactions, use the standard ANSI SQL command SET TRANSACTION ISOLATION LEVEL to define the transaction with a Repeatable Read or Serializable isolation level. For details, see Choosing transaction isolation levels in solidDB^® Administrator Guide.

Transactions must be ended with the COMMIT WORK or ROLLBACK WORK commands unless autocommit is used.