Rounding Function in Transformer satge

[Nageshsunkoji]

hai all,
Actually i am facing problem with Decimaltodecimal(----somecalculation),Round_inf) in Transformer Stage .This function giving proper rounding up to 17 digits.its not working properly for more than 18 digits number.can anybody suggest or any help regarding this matter.

Thanks & Regards
Nagesh

[Amit Jaiswal]

Hi Nagesh,
Please check the Environment Variable settings.
Default internal decimal variables are precision 38 scale 10, but this can be changed by specifying
$APT_DECIMAL_INTERM_PRECISION
$APT_DECIMAL_INTERM_SCALE
Set APT_DECIMAL_INTERM_ROUND_MODE to specify :
Ceil
Floor
Round_inf
Trunc_zero
I think your problem can be solved by using these evironment variables in your job and setting the values as per the requirements.
-Amit

[Nageshsunkoji]

Hi Nagesh,
Please check the Environment Variable settings.
Default internal decimal variables are precision 38 scale 10, but this can be changed by specifying
$APT_DECIMAL_INTERM_PRECISION
$APT_DECIMAL_INTERM_SCALE
Set APT_DECIMAL_INTERM_ROUND_MODE to specify :
Ceil
Floor
Round_inf
Trunc_zero
I think your problem can be solved by using these evironment variables in your job and setting the values as per the requirements.
-Amit

Hai Amit,

Thanks for u r input.But, i am using datastage version 7.1,that particular environment variables are not avialable.Can u give any suggestion on 7.1v .
Thanks&Regards
Nagesh

[Brethart]

Did u try adding to the user defined section of the Environment variables section?

hai all,
Actually i am facing problem with Decimaltodecimal(----somecalculation),Round_inf) in Transformer Stage .This function giving proper rounding up to 17 digits.its not working properly for more than 18 digits number.can anybody suggest or any help regarding this matter.

Thanks & Regards
Nagesh

[Nageshsunkoji]

Hi brethart,

Thanx for u r suggestion,i tried with the userdefined of the Environment variables section,but the results are not proper ? its not rounding the number properly.u have any other idea regarding this rounding function Please let me know.
Thanks&Regards
Nagesh

Did u try adding to the user defined section of the Environment variables section?

hai all,
Actually i am facing problem with Decimaltodecimal(----somecalculation),Round_inf) in Transformer Stage .This function giving proper rounding up to 17 digits.its not working properly for more than 18 digits number.can anybody suggest or any help regarding this matter.

Thanks & Regards
Nagesh