DB2 SQL-Error: -750
SQLState: 42986
Short Description: THE SOURCE TABLE CANNOT BE RENAMED BECAUSE IT IS REFERENCED IN EXISTING VIEW MATERIALIZED QUERY TABLE OR TRIGGER DEFINITIONS
The source table in a RENAME statement cannot be renamed because it is referenced in one or more existing triggers: v It is referenced in one or more materialized query table definitions v It is referenced as the triggering table in one or more existing triggers.System action: The statement cannot be executed. Programmer response: Change the source name to the name of an object that can be renamed and reissue the statement. Drop any triggers defined on the table before issuing the RENAME statement. These can be found by querying the system catalog: SELECT * FROM SYSIBM.SYSTRIGGERS WHERE TBNAME = Â’source-nameÂ’