sriranjan

• Aug 30th, 2006

 

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.

Dharmendra

• Aug 30th, 2006

 

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.

johney

• Sep 21st, 2006

 

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.

rajani

• Feb 21st, 2007

 

In the Filter option,u can use the UNIX command like this to filter the input records..

head -3 input_file.dat

dhora9999

 Profile Answers by dhora9999 Questions by dhora9999

• May 22nd, 2011

 

 Ya you are right, If you do not know the answer please do not cut paste here.

 Please answer the questions promptly. do not confuse anybody..

Thanks D!!