How to turn off rounding in a PX job?

[Marley777]

Hi, anyone know how to disable rounding in a PX job for decimal fields?

[ray.wurlod]

Review the rtype argument for decimal conversion functions.

[Marley777]

Hi Ray, started with the manual, but all the rtype options involve rounding of some kind. Is there another option?

[ray.wurlod]

How about floor?

[Marley777]

Using floor is working. Thanks Ray.

[karrisuresh]

HI Can you please explain me what do u mean by rounding the px job,
is it any particular field are yoy talking about??
Ray said using Floor function

too my knowledge it is used for a prticular field

please lemme know

thanks

[Marley777]

Based on my experience Datastage based on precision and scale will try to round decimal fields when doing logic or calculations within a transformer.

For String to Decimal
StringToDecimal(inputvalues,'floor') works but not work for expo values. However I avoid this issue because I'm not dealing with expo values in this scenario.

We are using decimal to decimal and it seems to be working.

DecimalToDecimal(inputvalues,'floor')