Rounding in PX

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
kd813
Participant
Posts: 20
Joined: Wed Feb 22, 2006 9:14 pm
Location: pune

Rounding in PX

Post by kd813 »

I have a decimal input and wanted to round it to one decimal place
ie if input is 2.34 output should be 2.3
ans if IP is 2.19 OP should be 2.2

Kindly provide a solution as to how to acgieve this
Top
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Contact ArndW

Post by ArndW »

you can use any of the conversion functions that have an rtype attribute and choose the rounding method of nearest in order to do that for you.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”