set column to default in db2

[krishrad]

i have a table with columns i have to alter two columns with default value as 'Y'. Please let me knwo how can i achieve it. i tried using the alter but it is not supporting the syntax. alter table <table name> alter column <column name> set default 'y';

i dont think db2 support this kind of alter. what is the better way. One way is to recreate the table. is there any better way for this.

 

[juliane26]

Which DB2 are you using ? z/OS ?
In LUW you should be able to do this.
In case its LUW: which error/sqlcode do you get ?

Juliane