MVSFORUMS.com

[vijay]

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]

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
www.linkedin.com/in/kolusu