June 09, 2003
Dropping Columns in DB2
I don't want to believe it, but according to this post at dBforums you can't drop a column from a table on DB2 UDB (the version which runs on Windows, AIX and Linux).
My reading of the reference manual seems to confirm this as well.
I fear I am coming across as a bit of a whinger, put it down to Monday-itis. But come on, we need this, especially on projects where we strive to be agile.
Posted by Andy Todd at June 09, 2003 05:42 PM
I would give my right arm to work in a company where they "strive to be agile". I'd even make the tea.
You might have to settle for a company which strives to make tea, Steve.
Oh, can you drop a column in UDB2/400, Steve? I don't have an iSeries to hand just right now...
The company I'm working for at the moment sort of make a tealike substance. Then they have a procedure for fixing it.
Best I can find on the iSeries is:
alter table library/table drop column
Ah, AS/400 gags, they take me back. Its a shame only Simon and Steve understand them really.
I am just thankful that I'm still working on a Unix like operating system and not having to suffer the slings and arrows of outrageous OS/390 - sorry, zSeries.
I think Oracle too lacked a drop/rename column functionality till version 8.