Need help in Modify Stage

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
prashanto_dev
Participant
Posts: 27
Joined: Thu May 22, 2003 4:40 am
Location: California

Need help in Modify Stage

Post by prashanto_dev »

I have to convert output of an aggregate field from an aggregator (Double) to an INTEGER field.
I can do it using Transformer. But I want to do it through Modify Stage. Please let me know the syntax to be used in specification in modify stage.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

decimal_from_decimal[trunc_zero](inputcol)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply