MVSFORUMS.com

[Lean]

i just want to drop the last three fields from a table, as following comments from IBM knowledge center.
To add a column, issue the following statement:
ALTER TABLE SALES
ADD COLUMN SOLD_QTY
SMALLINT NOT NULL DEFAULT 0
To delete or drop a column, issue the following statement:
ALTER TABLE SALES
DROP COLUMN SOLD_QTY

Can i try to drop multiple columns with following scripts.

[kolusu]

Lean,

AFAIK you can only drop 1 column at a time with ALTER command on z/OS. However you can drop the entire table and recreate the table without the columns you don't need which is a way of dropping more than 1 column at a time.
_________________
Kolusu
www.linkedin.com/in/kolusu

[Lean]

Hi Kolusu,

I saw one other forum that they said make it, is there any other way without recreating the table, because there are some data in the table. the data should be reloaded after recreating the table.i just want to save time. you can refer to below link which is the google result.

http://stackoverflow.com/questions/875291/how-can-i-drop-multiple-columns-in-db2-on-aix

[kolusu]

Lean,

The link is talking about AIX/WINDOWS. The DB2 version of z/OS is different from the open platform versions. On z/OS Drop column is supported in DB2 V11 which came out last September and AFAIK it only supports dropping a single column.

If you are concerned about reloading the table, then drop 1 column at a time and you wouldn't have to worry about unloading the data and then reloading it back again.
_________________
Kolusu
www.linkedin.com/in/kolusu

[Lean]

got it, thanks kolusu.