KFAA31524-E
The SQL statement cannot be executed, because the transaction access mode is "READ_ONLY". (M+J+O)
The SQL statement could not be executed because the transaction access mode is read-only. <SQLSTATE: 25006>
- S:
-
Ignores this SQL statement.
- Action:
-
When the transaction access mode is read-only, the only SQL statements that can be executed are SELECT statements. Use one of the following methods to change the transaction access mode to read/write, and then re-execute the SQL statement.
-
For the setReadOnly method of the JDBC driver's Connection interface, specify false.
-
For the Attribute argument of the ODBC driver's SQLSetConnectAttr, specify SQL_ATTR_ACCESS_MODE, and for the ValuePtr argument, specify SQL_MODE_READ_WRITE.
-
For the JDBC driver's adb_clt_trn_access_mode property (system property, user property, or property for connection URL), specify READ_WRITE.
-
For the Attribute argument of the CLI function a_rdb_SQLSetConnectAttr(), specify a_rdb_SQL_ATTR_ACCESS_MODE, and for the Value argument, specify a_rdb_SQL_ACCESS_MODE_READ_WRITE.
-
For the client definition's adb_clt_trn_access_mode operand, specify READ_WRITE.
-