By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,225 Members | 1,051 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,225 IT Pros & Developers. It's quick & easy.

Alter column from NOT NULL to NULL

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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

This discussion thread is closed

Replies have been disabled for this discussion.