MVSFORUMS.com

[manesh]

Hi

I am able to add one column to the db2 table using ALTER as shown below,

ALTER TABLE TABLE_NAME
ADD NEW_CLOUMN_NAME1 DECIMAL(11,2)

When I am trying to ADD 2 columns in the same query it is failing,

ALTER TABLE TABLE_NAME
ADD NEW_CLOUMN_NAME1 DECIMAL(11,2)
NEW_CLOUMN_NAME2 DECIMAL(11,2)

I tried to search in the fourm and Google and couldn't find and concrete sugestion.
We are using DB2 V8.Is it possible to add multiple coloumns with single ALTER statement in DB2 V8??

[Nic Clouston]

Looking at the syntax of ALTER TABLE ADD column you can only add one column per ALTER
_________________
Utility and Program control cards are NOT, repeat NOT, JCL.

[rrv]

Manesh

Try this:

ALTER TABLE TABLE_NAME
ADD COLUMN NEW_CLOUMN_NAME1 DECIMAL(11,2) ;

ALTER TABLE TABLE_NAME
ADD COLUMN NEW_CLOUMN_NAME2 DECIMAL(11,2) ;