ALTER TABLE DROP COLUMN Support

Article Id: 15373

Status: Published

Updated On: 14-02-2018 07:49

Legacy Id: TEC1084959

Products:

CA RC/Migrator , CA Endevor SCM Interface , DB2 Administration , CA RC Compare for DB2 for z/OS , CA RC Extract for DB2 for z/OS , CA RC/Query , CA RC Secure for DB2 for z/OS , CA RC Update 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