UTILITY for viewing data Selectively using a criteria

[vijayrc]

Hello All,
To help debug, we have lot of COPY stages and written to Datasets. I can always View this dataset in full. But from this dataset, if I need to selectively view, it isn't possible. How do I go about this.
One way I can do is copy this Dataset to a Sequential File, and once in Sequential File, Is there any available utility/tools available to selectively view certain criteria ???
Thanks in advance
Vijay

[splayer]

You can do:

orchadmin dump YourDS.ds SeqFile.txt

which puts your dataset in a sequential file. You can then use Unix commands to view specific rows.

[ArndW]

Or write a simple job with the dataset as the source, a constraint stage (perhaps a condition in a transform) and then output to a peek stage.

[vijayrc]

Or write a simple job with the dataset as the source, a constraint stage (perhaps a condition in a transform) and then output to a peek stage. ...

Thank You Sir, That was my original thought, but I'm trying to see if there are other ways of getting around this...Thanks again

[purush]

We are making a Job to read data from a .txt file and write it to a .ds file and using the dataset.

Is there any simpler way to do this,as orchadmin is there to copy .ds file to a .txt file.

Need Suggestions........

[DSguru2B]

I highly doubt it. You have to build a job as far as I know.