MVSFORUMS.com

vijay · Beginner Joined: 09 May 2003 Posts: 131 Topics: 64

Hi,

We added a new column to the existing table and defined it as NULLABLE.

We would like to change it to NOT NULL.

Could you help the best way to do this?

We are using DB2 version 12

Vijay

kolusu · Posted: Tue Jan 21, 2020 12:25 am Post subject:

vijay,

With ALTER command you can only change the default but not the nullability attribute. You have to DROP and recreate the table.

So you need to

1. Unload the table
2. Drop the table
3. Create the table with column set to NOT null with a default value
4. Modify the unload file from step1 to have a default value for the column whose prior value is null
5. Reload the table
6. REORG the table (not necessary but advisable)
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

www.linkedin.com/in/kolusu