ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

ALTER TABLE DROP COLUMN Support

book

Article ID: 15373

calendar_today

Updated On:

Products

RC Compare for DB2 for z/OS

Issue/Introduction



I only want to drop a column of a table with RC/Update alteration or a RC/Migrator strategy.

 

However, a DROP TABLE is generated instead of ALTER TABLE ..  DROP COLUMN ...

Environment

Release:
Component: RCM

Resolution

Please make sure there are no DB2 restrictions for dropping the column, e.g. if the containing table space is not a universal table space.

 

See a complete list here:

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/sqlref/src/tpc/db2z_sql_altertable.html

 

 (search for ‘A column cannot be dropped if any of the following conditions are true’)

Additional Information

ALTER TABLE DROP COLUMN Support

Powered by Wolken Software