DataStage MVS rounding problem

aesguerra · Post by **aesguerra** » Thu Nov 27, 2003 3:44 am

hi all,

we have bumped into trouble where the numeric data is being rounded off by datastage.

e.g.

PIC(15) is defined

123456789012345.99 * 0.1234567 = 123456789012345.123456789

we need all the 22 digits for use by the other computations but datastage is truncating and rounding it off making varying difference in the output amounts.

is there any workaround for this problem?

TIA.

Amos.Rosmarin · Post by **Amos.Rosmarin** » Thu Nov 27, 2003 4:21 am

I do not have MVS version infront of me right now but there is an option buth in the project properties and in the job properties to support big decimal values but i'm not sure it's the case.

Anyway, PIC(15) is not very cobolic .... it should be PIC S9(13)V9(9) COMP-3 meaning decimal(22,9) in datastage terms.

HTH,
Amos