ALTER staement to delete the multiple columns

T Prasad · New User Joined: 15 Feb 2011 Posts: 5 Location: Pune

Hi,

With the help of ALTER statement I want to delete the columns till 34.
Please find the attachment which contain the dataset screenshot

Regards,
Prasad Toshniwal

Attachment deleted

enrico-sorichetti · Posted: Wed Mar 16, 2011 12:38 pm

Do not post attachment, not everybody can see them
furthermore screen shots just waste space
a plain text cut and paste and the code tags will be more effective

as ( topic is unrelated but there are screenshots taken wit text cut and paste )
ibmmainframes.com/viewtopic.php?t=53264&highlight=ismf

T Prasad · New User Joined: 15 Feb 2011 Posts: 5 Location: Pune

Hi,

Please ignore the attachment and advice on my query.

Regards,
Prasad T

GuyC · Posted: Wed Mar 16, 2011 2:40 pm

now you should post the sql as text before we can advice.
But you can not ALTER TABLE DELETE COLUMNS

rakesh1155 · New User Joined: 21 Jan 2009 Posts: 84 Location: India

Hello,

I thought that was one big difference in DB2 compared to other databases like ORACLE... (though there would be many differences)

One cannot delete columns in DB2 by ALTER command. If a column has to be deleted, it can only be done by DROP and CREATE TABLE.

Please correct me if I am mistaken.

-Thanks,
Rakesh.