DB2 SQL-Error: -20093

Short Description: THE TABLE CANNOT BE CONVERTED TO OR FROM A MATERIALIZED QUERY TABLE OR THE MATERIALIZED QUERY TABLE PROPERTY CANNOT BE ALTERED REASON CODE C M T M M M T C P ALTER TABLE ADD MATERIALIZED QUERY E ALTER TABLE

The ALTER TABLE statement was not able to change a table from a materialized query table to a base table, to convert a base table to a materialized query table, or to change the materialized query table properties. The ALTER TABLE statement failed because of one of the following error situations, as indicated by reason-code: reason-code Description 2 The table is not a materialized query table, and DROP MATERIALIZED QUERY is specified. 4 The table has at least one trigger defined. 5 The table has at least one check constraint defined. 6 The table has at least one unique constraint or index defined. 7 The table has at least one referential constraint defined. 8 The table is referenced in the definition of an existing materialized query table, or it is referenced in the definition of a view when altering to a system-maintained materialized query table. 9 The table is referenced directly or indirectly (through a view, for example) in the fullselect. 10 The table is already a materialized query table. 11 The number of columns of the existing table does not match the number of columns that are defined in the select list of the fullselect. 12 The data types of the columns of the existing table do not exactly match the corresponding columns in the select list of the fullselect. 13 The column names of the columns of the existing table do not exactly match the corresponding column names in the select list of the fullselect. 14 The nullability, default, or other characteristics of the columns of the existing table do not exactly match the characteristics of the corresponding columns in the select list of the fullselect. 15 The conversion cannot be performed if there are any other table alterations in the same ALTER TABLE statement. 16 The table is not a materialized query table, and alteration of materialized query table properties was specified.System action: The statement cannot be processed. Programmer response: Depending on reason-code, take the following action: reason-code Action 2 There is no need to convert this table. No action is required. 4 Drop any triggers, and try the ALTER TABLE statement again. 5 Drop any check constraints, and try the ALTER TABLE statement again. 6 Drop any unique constraint and unique indexes. Try the ALTER TABLE statement again. 7 Drop the referential constraints, and try the ALTER TABLE statement again. 8 Drop the materialized query table that references the table, and try ALTER TABLE statement again. 9 A materialized query table cannot reference

 <-  BACK TO INDEX