For UDB this function is being written right now...in v8 there's a gui
tool that will automate the steps required to change a table's column
types, remove columns etc, but nothing in v7.
Tilmann wrote:
I'm currently using UDB 7.2 on WIN 2000 and also DB2 Version 7 on
z/OS.
I have one table with a column defined as NOT NULL. I had to change
this column from NOT NULL to NULL. Is there any better way than
UNLOAD, DROP TABLE, CREATE TABLE and LOAD? I didn't find anything in
the alter table statement in this direction?