Page 1 of 1

Error code -650 when droppping columns from DB2 table

PostPosted: Sat Feb 06, 2016 3:45 pm
by MFDEV
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 ?

Re: Error code -650 when droppping columns from DB2 table

PostPosted: Sat Feb 06, 2016 4:11 pm
by NicC
Please do not hijack other people's topics. Always start a new topic for EACH query that you have. Topic split.

Re: Error code -650 when droppping columns from DB2 table

PostPosted: Sat Feb 06, 2016 4:40 pm
by MFDEV
Thanks Nicc. I have posted this as a new topic.