IBM Mainframe Forum

Hi,

I am create one table. In this table have 4 columns as name, fname, city, zipcode, phoneno.
i am successfully create the table. But i need to drop a column but it not drop it has show some error.

ALTER TABLE CARD DROP COLUMN CITY

It has show the following error msg.
SQL error at or before (line 6, position 23).
Pls any one help me
Thanks in advance.
Regards,
Madhavan

why don ' You look at the manual for the DB2 version You are using to check if the DROP clause is allowed ???

hi,

i was seen that but it wont work. i have worked on the QMF.
Pls help me to alter a particular column and drop a particular column.

Regards,
madhavan

madhavan wrote:i was seen that but it wont work. i have worked on the QMF.

This is incomprehensible. If you are unable to communicate clearly, there is no place for you in IT.