DB2 SQL-Error: -817
SQLState: 25000
Short Description: THE SQL STATEMENT CANNOT BE EXECUTED BECAUSE THE STATEMENT WILL RESULT IN A PROHIBITED UPDATE OPERATION C DBMS DBMS I DBMS I
The application attempted to execute an SQL statement that would result in updates to user data or to the subsystem catalog. This is prohibited for one of the following reasons: v The application is running as an IMS inquiry-only transaction. v The application is an IMS or CICS application that is attempting to update data at a remote DBMS that does not support two-phase commit. v The application is attempting to update data at multiple locations and one of the locations does not support two-phase commit. v A trigger defined with activation time BEFORE was activated and its triggered action caused updates to the database.These SQL statements include INSERT, UPDATE, DELETE, CREATE, ALTER, DROP, GRANT, and REVOKE. System action: The statement cannot be executed. Programmer response: If the application is running as an IMS inquiry-only transaction, see your IMS system programmer about changing the inquiry-only status of the transaction under which your application is running. If the IMS or CICS application is attempting a remote