Error code -650 when droppping columns from DB2 table



IBM's flagship relational database management system

Error code -650 when droppping columns from DB2 table

Postby MFDEV » Sat Feb 06, 2016 3:45 pm

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 ?
MFDEV
 
Posts: 15
Joined: Mon Dec 01, 2014 3:25 pm
Has thanked: 2 times
Been thanked: 0 time

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

Postby NicC » Sat Feb 06, 2016 4:11 pm

Please do not hijack other people's topics. Always start a new topic for EACH query that you have. Topic split.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

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

Postby MFDEV » Sat Feb 06, 2016 4:40 pm

Thanks Nicc. I have posted this as a new topic.
MFDEV
 
Posts: 15
Joined: Mon Dec 01, 2014 3:25 pm
Has thanked: 2 times
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post