2.9.5 Transaction access modes
Transaction access modes are used to control the SQL statements that are executed in a transaction. HADB supports the following transaction access modes:
-
Read/write mode
-
Read-only mode
- Note
-
You can use either the adb_clt_trn_access_mode operand in the client definition or the connection attribute to specify a transaction access mode. For details about the client definition and the connection attribute, see the HADB Application Development Guide.
- Organization of this subsection
(1) Read/write mode
When a transaction is started in the read/write transaction access mode, that transaction becomes a read/write transaction.
A read/write transaction can execute all SQL statements.
(2) Read-only mode
When a transaction is started in read-only transaction access mode, that transaction becomes a read-only transaction.
A read-only transaction cannot execute definition SQL statements or update SQL statements.
A read-only transaction can execute the SQL statement listed in the following.
- ■ SQL statement that can be executed in a read-only transaction:
-
-
SELECT statement
-