ALTER TABLE DROP COLUMN Support

Document ID:  TEC1084959
Last Modified Date:  08/10/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA RC/Migrator for DB2 for z/OS
  • CA RC/Update for DB2 for z/OS

Releases

  • CA RC/Migrator for DB2 for z/OS:Release:18.0
  • CA RC/Migrator for DB2 for z/OS:Release:19.0
  • CA RC/Update for DB2 for z/OS:Release:18.0
  • CA RC/Update for DB2 for z/OS:Release:19.0

Components

  • CA RC/Migrator for DB2 for z/OS:RCM
  • CA RC/Update for DB2 for z/OS:RCU
Question:

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 ...

Answer:

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:

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >