Filter data with length

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
dr.murthy
Participant
Posts: 224
Joined: Sun Dec 07, 2008 8:47 am
Location: delhi

Filter data with length

Post by dr.murthy »

Hi

Can we filter the data based on length of a field using filter stage ???
D.N .MURTHY
Top
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

Filter Stage: Supported Boolean expressions and operators

Correcting the URL...

http://publib.boulder.ibm.com/infocente ... ators.html
Last edited by qt_ky on Tue Feb 21, 2012 5:57 pm, edited 1 time in total.
Choose a job you love, and you will never have to work a day in your life. - Confucius
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

You can calculate the length upstream. But if you're going to do that in a Transformer stage, you may as well use the Transformer stage's ability to filter rows using constraint expressions.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

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