Transformer Rounding

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
gooogle
Participant
Posts: 42
Joined: Tue Feb 23, 2010 3:40 pm

Transformer Rounding

Post by gooogle »

How do I round off:

12.1 to 12
12.9 to 13
from a transformer

I tried NumericRound0 but it makes 12.1 to 12 & 12.9 also to 12.

The syntax for CEIL ?
CEIL(InputColumn) wont work.

Thanks for any help ...
Top
BradMiller
Premium Member
Premium Member
Posts: 87
Joined: Mon Feb 18, 2008 3:58 pm
Location: Sacramento, CA

Post by BradMiller »

Try DecimalToDecimal(InputColumn,"round_inf"). Make sure to set your output column to decimal with a scale of zero.
Top
Post Reply

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