Orchadmin - Search

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
vijaykumarpj
Participant
Posts: 30
Joined: Sat Dec 19, 2009 5:19 am
Location: Manchester, UK

Orchadmin - Search

Post by vijaykumarpj »

Hi,

Do we have any Orchadmin Utilities to search the data from the dataset thru UNIX ?
Thanks,
VJ.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

I don't believe so, I think all you can do is dump the data and then use your search mechanism of choice, like grep for instance.
-craig

"You can never have too many knives" -- Logan Nine Fingers
bcarlson
Premium Member
Premium Member
Posts: 772
Joined: Fri Oct 01, 2004 3:06 pm
Location: Minnesota

Post by bcarlson »

You could create a simple parameterized DS job and pass a dataset name, filter and record count. Job is

dataset -> Filter -> Peek

You could run it from Director or from the Unix command line with dsjob. The output from PEEK is the same as what you would get from the orchadmin dump command. In fact, when you run orchadmin dump, it is essentially generating the same program under the covers (sans filter).

Brad.
It is not that I am addicted to coffee, it's just that I need it to survive.
Post Reply