Search for records in enterprise datasets in one pass

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
NigeGriff
Premium Member
Premium Member
Posts: 46
Joined: Mon Nov 24, 2003 5:46 am

Search for records in enterprise datasets in one pass

Post by NigeGriff »

Is it possible to search through all the records of a large volume dataset for column values without having to use the view options in the dataset stage and in dataset manager.
Thanks
Nigel
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

I assume you mean you want to do this outside of a job, right?

From UNIX you could do something like:

Code: Select all

orchadmin dump /path/to/your/dataset.ds | grep {stringvalue}
NigeGriff
Premium Member
Premium Member
Posts: 46
Joined: Mon Nov 24, 2003 5:46 am

Post by NigeGriff »

Yes that sounds good.

Can it be adapted to search a specific column within the record?
Thanks
Nigel
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

Code: Select all

orchadmin dump -field {fieldName} {datasetName} | grep {searchString}
Post Reply