Drop column from table

[Twan Kennis]

How can I drop a column from an existing table:

CREATE TABLE table1 (column1 integer, column2 integer)

succeeds.

ALTER TABLE table1 DROP COLUMN column2

turns into an error "Error: [IBM][iSeries Access ODBC Driver]Operation
cancelled."

Specs:
- Database: DB2-database/ IBM OS400
- SQL Interface: Client Access ODBC Driver, version 9.00.07.00

Greetings, Twan Kennis

[Hardy]

I'm not familiar with DB2/400 but I think drop colum is also not
supported as that of UDB. have you check the sql referece?

[malla]

ya there is no command to drop the column and we cannot trunacte the
data of the table also for that u have to recreate the table with the
required columns

[Visu]

You should be able to if you have ALTER privileage

http://publib.boulder.ibm.com/html/a...fzmstatabl.htm

[4.spam]

Hello.

DB2/400 does support dropping a column but some strange way.
If you invoke this command from strsql utility (from 5250 terminal
window) you will notice, that it asks you something "are you sure you
really want to do this?" and will wait for your input. After you type
'I" symbol it will drop your column.
Since you can't invoke interactive sql commands from iSeries client
window, you can't successfully invoke this command from this window.
May be there is some way to adjust OS400 to invoke immediately dropping
a column without confirmation, but I don't know it...

Sincerely,
Mark B.