DB2 SQL-Error: -20180
SQLState: 428FR
Short Description: COLUMN IN TABLE CANNOT BE ALTERED AS SPECIFIED
Column column-name cannot be altered for one of the following reasons: v ALTER COLUMN cannot be specified on ALTER TABLE if: – The table is defined with DATA CAPTURE CHANGES – The column is involved in a referential integrity constraint (either as part of the parent key or foreign key) – The column has a field procedure defined – or the column is an identity columnv Additionally, SET DATA TYPE cannot be specified on ALTER TABLE if: – The table is a materialized query table – The table has an edit procedure or valid procedureSystem action: The statement cannot be executed. Programmer response: Change the name of the column to a column that can be altered, or drop and recreate the table with the necessary attributes.