Page 1 of 1
Rounding Function in Transformer satge
Posted: Wed Aug 31, 2005 7:37 am
by 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
Change Environment Variable values
Posted: Wed Aug 31, 2005 8:18 am
by 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
Re: Change Environment Variable values
Posted: Wed Aug 31, 2005 9:26 am
by Nageshsunkoji
Amit Jaiswal wrote: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
Re: Rounding Function in Transformer satge
Posted: Wed Aug 31, 2005 10:40 am
by Brethart
Did u try adding to the user defined section of the Environment variables section?
Nageshsunkoji wrote: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
Re: Rounding Function in Transformer satge
Posted: Thu Sep 08, 2005 2:31 am
by 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
Brethart wrote:Did u try adding to the user defined section of the Environment variables section?
Nageshsunkoji wrote: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