-20235 THE COLUMN `column-name` CANNOT BE ADDED, ALTERED, or DROPPED BECAUSE `table-name` IS A MATERIALIZED QUERY TABLE

Explanation
 The
alter table statement attempted to add, alter, or drop column column-name of
materialized query table table-name. This is not
allowed.

System action
 The statement cannot be processed.

Programmer response
 Columns of materialized
query tables cannot be added, altered, or dropped. Alter the materialized
query table to become a regular table before adding, altering, or
dropping a column.

SQLSTATE
 428FY

-20235 THE COLUMN column-name CANNOT BE ADDED, ALTERED, or DROPPED BECAUSE table-name IS A MATERIALIZED QUERY TABLE

Explanation

System action

Programmer response

SQLSTATE

-20235 THE COLUMN `column-name` CANNOT BE ADDED, ALTERED, or DROPPED BECAUSE `table-name` IS A MATERIALIZED QUERY TABLE