Monday, January 10, 2011

How to change a NOT NULL column to allow NULLs?

ALTER TABLE Keyword does not seem to have this ability. A column that allows
NULL is one byte wider than a NOT NULL column, therefore you will need a
new page layout. So even if there was a command like ALTER TABLE...ALLOW
NULL, DB2 would have to do all the steps you described.
Need Import the data and export it and make the required changes.

No comments:

Post a Comment