NEG function automatically rounding decimals
Posted: Thu Feb 02, 2012 3:58 pm
Hi,
New to DataStage and trying to understand why my numeric value of 4321.12345 is automatically rounded up to two decimal points when I have the following derivation defined in my transform
NEG(DSLink1.DECIMAL_NUMBDER[1,21]) will return -4321.12 but I need -4321.12345 to be displayed.
If I remove the NEG function the full value comes through as expected but obviously without the preceeding minus sign. I need to have the ability to convert the number to a negative value and using the NEG function was the easiest way I have found so far - just don't understand how to stop the rounding.
All thoughts are appreciated!
TIA,
Test1973
New to DataStage and trying to understand why my numeric value of 4321.12345 is automatically rounded up to two decimal points when I have the following derivation defined in my transform
NEG(DSLink1.DECIMAL_NUMBDER[1,21]) will return -4321.12 but I need -4321.12345 to be displayed.
If I remove the NEG function the full value comes through as expected but obviously without the preceeding minus sign. I need to have the ability to convert the number to a negative value and using the NEG function was the easiest way I have found so far - just don't understand how to stop the rounding.
All thoughts are appreciated!
TIA,
Test1973
Once it was changed to the correct precision, the value was passing through correctly.