KFAA31524-E

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.