Division truncation

[juliejarrett]

In the Transformer I am tring to do a division and the answer keeps truncating

ie 1 / 3 = .33330 The scale we specified was 5.

Any ideas how we could get .33333

Thanks

[loveojha2]

Are you writing the result directly from the transformer to the target(may be seq file,Hashed file or db table)? Is there any other stage in between the target and the transformer? What is the data type in your target and what the data type you are using in the map?

[ray.wurlod]

The default PRECISION in DataStage is 4.

The only way you can change this is to perform your calculation in a Routine, in which a PRECISION statement appears to change that value.

Code: Select all

FUNCTION DivideByThree(Arg1)

PRECISION 9

Ans = Fmt((Arg1) / 3, "MR9")

RETURN(Ans)