IBM Mainframe Forum

Hi All, I am getting -650 error code , Reason 24 while trying to drop column from the table as ALTER TABLE DATABASENAME.TSNAME DROP COLUMN COLUMN1 RESTRICT . I have tried Reorg tablespace and before that took image copy but still getting same error.

Error message: 24
An ALTER TABLE statement with pending options is allowed only for universal table spaces.

Any help ?

Please do not hijack other people's topics. Always start a new topic for EACH query that you have. Topic split.

Thanks Nicc. I have posted this as a new topic.