I am trying to drop a column from the table ASSOCIATED_PAGE_QUESTION and I give the following command
ALTER TABLE ASSOCIATED_PAGE_QUESTION DROP COLUMN question_name

There are no constrains associated to this column however this gives me the following error

ALTER TABLE ASSOCIATED_PAGE_QUESTION DROP COLUMN question_name
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "COLUMN" was found following "D_PAGE_QUESTION
DROP". Expected tokens may include: "CONSTRAINT". SQLSTATE=42601

Can someone help me out

What DB2 version and OS?

Andy

Thanks for responding Andy,
its IBM DB2 Universal Database 8 FP 6a

and the OS is AIX 5.3

ALTER TABLE ... DROP COLUMN is a new feature starting at V 9.1.

That is why you are getting the error.

Andy

Ohh thanks .. so is there an alternative way to do this? I am searching online as well

also is there a way to rename a column?

1. drop and rebuild the table

2. create a view to rename this column

3. upgrade

There is altobj that you can use to drop/rename the column, but I believe it's only available starting with v8 fp7:
DB2 Universal Database

altojb has some problems so consider upgrading to the latest fixpak if you're going to use it.

Thanks for all ur inputs.. I got the DBA to drop the table and create a newone.

Did you get him a doughnut? It will help you in the future