we cant filter datas in sequential file.we can only filter the datas in database stage or in transformer stage.In database stage thru SQL statements ,we can filter.In tranformer filter conditions can be written in constraints.I don think so other than this steps we cant filter in datastage.
Filter command. you can specify a filter program that will process the data before it is written to the file. This could be used,for example, to specify a zip program to compress the data. You can type in or browse for the filter program, and specify any
command line arguments it requires in the text box. This text box is enabled only if you have selected the Stage uses filter commands checkbox on the Stage page General tab (see page 8-1). Note that, if you specify a filter command, data browsing is not available so the View Data button is disabled.
The first solution is correct to some extent. But I thought there is a way as per the second solution. The second solution given is very clever, I don't think the people are copying and paste the help content appearing in the DataStage (DataStage devs who doesn't know this... Think!). This is not a good practice. If you want to give right solutions with example then it will be helpful to the needful people.
