DB2 UDB V8.2 does allow you to do this. You can upgrade your DB2 server to
V8.2 by installing FixPak 7a. Get it here
http://www-306.ibm.com/software/data/db2/udb/support/downloadv8.html

Leon Katsnelson
Program Director, Competitive Technology.
IBM Toronto Lab
tel: (905) 413-2119
Admin Assistant: Cynthia Thomson (905) 413-3632







"Michael Kleiser
"
<db2udbdba-ezmlms To
hield-x52655470.x "LazyDBA Discussion"
[Email Address Removed] <[Email address protected]
a.com> cc

10/28/2004 07:35 Subject
AM How to change a column from "NOT
NULL" TO "NULL"










In DB2 8.1
I have defined a colum, not to allow null-values

Now I do wan't to allow them.
How can I do this ?

I Oracle it would be
ALTER TABLE tablename MODIFY columnname NULL






---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




DB2 & UDB email list listserv db2-l LazyDBA home page