Sunday, July 15, 2007

Grep a DataStage dataset

Here is how you could run a grep command on a DataStage dataset.
First set the environment.
/apps/Ascential/DataStage/DSEngine> . dsenv
Then you will be good to go. Remember, Orchadmin works only from the bin folder.
/apps/Ascential/DataStage/PXEngine.700.1/bin> orchadmin dump DataSetWithPathName.ds | grep -i "Field Name"

No comments: