-20106 THE CCSID FOR THE 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 OR AN EXTENDED INDEX
Explanation
An ALTER statement cannot be used to alter the CCSID for a table space or database that contains a table that is referenced in an existing view, or materialized query table definitions, or a table that already has an extended index.
System action
The statement cannot be processed.
Programmer response
To alter the CCSID for
the specified space, complete the following steps:
- Drop any existing view or materialized query table definitions that refer to tables contained in the identified space.
- Drop all of the extended indexes created on the table.
- Reissue the ALTER statement.
SQLSTATE
42945