DB2 SQL-Error: -150
SQLState: 42807
Short Description: THE OBJECT OF THE INSERT DELETE OR UPDATE STATEMENT IS A VIEW SYSTEMMAINTAINED MATERIALIZED QUERY TABLE OR TRANSITION TABLE FOR WHICH THE REQUESTED OPERATION IS NOT PERMITTED C T A U T GROUP BY HAVING T SELECT DISTINCT A D T GROUP BY HAVING T SELECT DISTINCT A INSERT UPDATE DELETE S REFRESH TABLE S T N P T R C DB SQL R I CREATE TRIGGER INSERT UPDATE DELETE I R REFRESH TABLE C
One of the following occurred: v A transition table was named in an INSERT, UPDATE, or DELETE statement in a triggered action. Transition tables are read-only. v The view named in the INSERT, UPDATE, or DELETE statement is defined in such a way that the requested insert, update, or delete operation cannot be performed upon it. Inserts into a view are prohibited if: – The view definition contains a join, a GROUP BY, or a HAVING clause. – The SELECT clause in the view definition contains the DISTINCT qualifier, an arithmetic expression, a string expression, a built-in function, or a constant.