DSXchange

Posted: **Wed May 27, 2009 5:55 am**

Hi All,

Could you please help me how can filter the records in sequential stage?

Posted: **Wed May 27, 2009 5:59 am**

The parallel job dev guide will help you no end... it's an option you can add to the stage, called 'filter'

This will allow you to make a call to filter as desired. As an input, it filters before writing, as an output, it filters before reading... as explained in the product documentation

Posted: **Wed May 27, 2009 5:59 am**

Give more details about nature of file and what you want to filter ..
You can use filter option in sequential file stage .

Posted: **Wed May 27, 2009 6:06 am**

Hi all,
thanks for reply

if i'm wrong please correct me
i have used "Filter" option in sequential file in that i have used unix command. is there any process is there ?

Posted: **Wed May 27, 2009 6:10 am**

Using a unix command in the filter is correct yes, I'm not sure about the "is there any process is there"

Posted: **Wed May 27, 2009 6:18 am**

Hi miwinter,

thanks for the reply,in sequential file we have option "Read first Rows" like this also we can filter the records right?

Posted: **Wed May 27, 2009 6:23 am**

yes you can ...

Posted: **Wed May 27, 2009 6:31 am**

Yes, but I wouldn't call this filtering exactly, effectively it's just take the first x records... filtering would apply further logic in my book