Numeric conversion

[marco.mir]

Hello,

sorry for the question which could be stupid for someone, but how can I convert a Numeric (length 6, scale 3) to a Decimal (length 3, scale 3)?

Thanks in advance.

[ray.wurlod]

You can use DecimalToDecimal() function. But beware that you are potentially trying to load large values into a data type that is not big enough to store them, so DataStage will unavoidably generate an alert message to this effect. (Tou can, of course, use a message handler to demote his alert to informational.)