Query to increase scale size of column db2

[PavithraM]

Hi,

Need to increase the scale length of column

I have executed the below query :

ALTER TABLE W0PS2$.TTAUDM
ALTER COLUMN VAL_TAUX
SET DATA TYPE DEC(11,10);

I got below error:

---------+---------+---------+---------+---------+---------+---------+---------+
DSNT408I SQLCODE = -190, ERROR: THE ATTRIBUTES SPECIFIED FOR THE COLUMN VAL_TAUX ARE NOT COMPATIBLE WITH THE EXISTING COLUMN DEFINITION
DSNT418I SQLSTATE = 42837 SQLSTATE RETURN CODE

Note:The column VAL_TAUX size is decimal(10,5) as of now. I need to increase it as decimal(11,10)

Kindly please post your suggestions.

Thanks,
Pavithra