Number must be postive value, if negative reject

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
e1994264
Premium Member
Premium Member
Posts: 28
Joined: Mon Jul 18, 2011 5:12 pm

Number must be postive value, if negative reject

Post by e1994264 »

Hi,
I am reading data from mainframe system. we are getting negative and positive value for partcular column. What are functions do we need in transformation stage for checking the Positive and Negative value of a particular column

Transformation rules:
Number must be postive value, if negative reject
SURA
Premium Member
Premium Member
Posts: 1229
Joined: Sat Jul 14, 2007 5:16 am
Location: Sydney

Re: Number must be postive value, if negative reject

Post by SURA »

Val < 0
Thanks
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

InLink.Value >= 0 on output link constraint.
InLink.Value < 0 on reject link. You could also employ Otherwise/Log for this link.
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