I have a table that has an identity column in it. It was created
generated always and now I would like (need) it to be generated by
default. I tried to use the alter table xx alter column, but I don't
know how the set the 'SET DATA TYPE' option on the alter statement.
Does anyone know how I can change the column(it's an integer) from
generated always to generated by defult?

I am runnin DB2 v7 on zSeries.