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
NEG function automatically rounding decimals
Moderators: chulett, rschirm, roy