Increase Decimal length in v7.x

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

narenmehta@gmail.com - 30 Dec 2004 21:17 GMT

I need to increase the value of a Decimal(4) to Decimal(10)
I tried the following and it doesnt work.
ALTER TABLE xyz ALTER COLUMN PAGE SET DATA TYPE DECIMAL(10);

Reply to this Message

Serge Rielau - 30 Dec 2004 23:27 GMT

> I need to increase the value of a Decimal(4) to Decimal(10)
> I tried the following and it doesnt work.
> ALTER TABLE xyz ALTER COLUMN PAGE SET DATA TYPE DECIMAL(10);

DB2 UDB for LUW cannot do this with ALTER TABLE. In V8.2 there is
support for what you ask for through control center.
The feature is on the to-do list.
Cheers
Serge

Reply to this Message