Delete datasets and query dataset in UNIX

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
DSGuru79
Charter Member
Charter Member
Posts: 12
Joined: Thu Nov 09, 2006 8:57 pm

Delete datasets and query dataset in UNIX

Post by DSGuru79 »

Hi,

I just want to delete the datasets using unix shell script. Also want to view particular record in dataset thru unix.

This is possible thru orchestrate command (ORCHADMIN). If anyone have tried this, can please tell me the commands for these both.

Thanks
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

Do a search my friend. This has been discussed here before. Like thisfor instance.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
us1aslam1us
Charter Member
Charter Member
Posts: 822
Joined: Sat Sep 17, 2005 5:25 pm
Location: USA

Post by us1aslam1us »

Code: Select all

orchadmin rm datasetname
you can use this command in your script to delete the dataset. I am not sure how you can view that thru unix.

Thanks
Sam
DSGuru79
Charter Member
Charter Member
Posts: 12
Joined: Thu Nov 09, 2006 8:57 pm

Post by DSGuru79 »

All,

Thanks for your inputs. It worked. Just I put that syntax in shell script and it deleted.

I also did a search in forum on querying the dataset. But I did not get any topics on that. I want to know any particular string is present on that dataset, uisng commands like orchadmin or any other command.

Appreciate your help.

Thanks
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Look in the Orchestrate Administrator manual for all options to orchadmin (or simply execute orchadmin with no command line arguments).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply