The following syntax works on DB2 for iSeries. Try it on your
implementation.

alter table MyTable
alter column MyColumn
drop not null



The information contained in this e-mail message and any attachments is confidential and intended only for the addressee(s). If you are not an addressee, you may not copy or disclose the information, or act upon it, and you should delete it entirely from your email system. Please also notify the sender that you received this e-mail in error.
-----Original Message-----
From: Michael Kleiser
[mailto:db2udbdba-ezmlmshield-x52655470.[Email address protected]
Sent: Thursday, October 28, 2004 4:35 AM
To: LazyDBA Discussion
Subject: 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

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