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 table space 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 ?

Use the DISPLAY DATABASE command with the SPACENAM keyword to determine the status of the table space in question, and take the appropriate action(s) to return it to RW status.

These users thanked the author Akatsukami for the post:

MFDEV (Thu Aug 04, 2016 9:59 am)

Thanks for the details and I found that it is segment table space which needs to be converted to UTB first to clear this error.