logo  
Google
 

DB2 SQL-Error: -20106

SQLState: 42945

Short Description: THE CCSID FOR TABLE SPACE OR DATABASE CANNOT BE CHANGED BECAUSE THE TABLE SPACE OR DATABASE ALREADY CONTAINS A TABLE THAT IS REFERENCED IN EXISTING VIEW OR MATERIALIZED QUERY TABLE DEFINITIONS

An ALTER statement cannot be used to alter the CCSID for a table space or database that contains a table that is referenced in existing view or materialized query table definitions. System action: The statement cannot be executed. Programmer response: To alter the CCSID for the specified space, first drop any existing view or materialized query table definitions that refer to tables contained in the identified space and then reissue the ALTER statement.

 <-  BACK TO INDEX