How to search a particular record/row in a Dataset

neeharika · Post by **neeharika** » Sun Dec 04, 2011 9:52 pm

Hi ,

I am new to Datastage. I have a job where the ouput stage is a dataset. The dataset contains millions of records. Now, I want to search a particular record from those million records and check it. Is there a way we can do it?
My problem is because Dataset cannot be viewed outside datastage.

Thanks in advance

-Neeharika

ray.wurlod · Post by **ray.wurlod** » Sun Dec 04, 2011 10:31 pm

A Data Set can be viewed outside of DataStage, using the orchadmin command (search DSXchange or the manuals for more information). However there is no scope for selection; you can only read all rows (then, possibly, pass them through a filter of your choice).

qt_ky · Post by **qt_ky** » Mon Dec 05, 2011 7:50 am

You could create a new job to read the dataset, pass it through a Filter or Transformer stage, and output to Peek or Sequential File stage.

sanjayS · Post by **sanjayS** » Mon Dec 05, 2011 9:33 am

If you know the particular record you want, you can search using the Find option which appears once dataset is opened.

Thanks,
Sanjay.