I have a table that has a column defined as char(2), default ' '... I want to change the default to NULL, but nothing I am doing is working... I used: "alter table pubwrksf.Material alter column InvnType set not null" which gives the meaningless to me - SQL0952 reason code 10... I have tried to drop existing default first, change the default to something else, and other options, but nothing allows me to use set not null (which is how the DB2 for i documentation says its done) on that column... Any ideas???