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
Rounding Function in Transformer satge
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 222
- Joined: Tue Aug 30, 2005 2:07 am
- Location: pune
- Contact:
Rounding Function in Transformer satge
NageshSunkoji
If you know anything SHARE it.............
If you Don't know anything LEARN it...............
If you know anything SHARE it.............
If you Don't know anything LEARN it...............
-
- Premium Member
- Posts: 38
- Joined: Fri Apr 22, 2005 6:07 am
Change Environment Variable values
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
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
-
- Participant
- Posts: 222
- Joined: Tue Aug 30, 2005 2:07 am
- Location: pune
- Contact:
Re: Change Environment Variable values
Hai Amit,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
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
NageshSunkoji
If you know anything SHARE it.............
If you Don't know anything LEARN it...............
If you know anything SHARE it.............
If you Don't know anything LEARN it...............
Re: Rounding Function in Transformer satge
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
-
- Participant
- Posts: 222
- Joined: Tue Aug 30, 2005 2:07 am
- Location: pune
- Contact:
Re: Rounding Function in Transformer satge
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
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
NageshSunkoji
If you know anything SHARE it.............
If you Don't know anything LEARN it...............
If you know anything SHARE it.............
If you Don't know anything LEARN it...............