I 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 ...
Release: R19 and R20
Ensure that 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:
(search for ‘A column cannot be dropped if any of the following conditions are true’)
This ability was introduced in R19 release:
ALTER TABLE DROP COLUMN Support
Note that in RC/Migrator , a column is signified to be dropped when editing the table in question and a "D" delete line command is used inside the strategy to delete the column.
The Analysis then decides based on the DB2 rules for the associated tablespace type and other analysis settings if it will utilise a ALTER TABLE DROP COLUMN statement or it may just drop and recreate the table.