Dear All,

Could u pls help me this? I would like to change one of table column data type from Decimal to Integer in DB2 UDB 7.1(window version).
I don't see any function to change in Control center or don't see the command in information center reference.
May I know I can do that or not?
If yes,how to do it?
If not,is there any suggetion pls?

Help me pls

Thanks,

Hi,
1. rename table
2. create table with integer column definitions
3. execute sql: insert into new_table select * from old_table.

Hope this helps,
Grofaty

Thanks a lot, grofatty.
Really appreciate your suggetion.