Hi,

I'm trying to change a column on a DB2 table so that it has a default value
but I cannot get it to work. Does anyone have any experience in this area.

I'm trying with this statement:

Alter Table x
           Alter column y default 0;

I also tried with this:

Alter Table x
           Alter Column y Set Data Type SmallInt With Default 0;

And this:

Alter Table x
           Alter Column y Set Default 0;

I simply cannot make it work ;o(

Thanks in advance

Kimi