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