Alter column from NOT NULL to NULL

Tilmann

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?

Nov 12 '05 #1

Sean McKeough

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?

Nov 12 '05 #2