NEG function automatically rounding decimals

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Test1973
Participant
Posts: 2
Joined: Wed Feb 01, 2012 5:40 pm

NEG function automatically rounding decimals

Post by Test1973 »

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
Test1973
Participant
Posts: 2
Joined: Wed Feb 01, 2012 5:40 pm

Post by Test1973 »

My bad - total NOOB here.

Didn't realize I had the wrong data type definition in my stage variable in the transform. :oops: Once it was changed to the correct precision, the value was passing through correctly.

Thanks!
Post Reply