Need to delete temporary datasets after jobs get completed

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
SagarMelam
Participant
Posts: 26
Joined: Mon Apr 21, 2008 4:03 am
Location: Amalapuram

Need to delete temporary datasets after jobs get completed

Post by SagarMelam »

Hi,
Need to know the script for deleting temporary datasets created after sucessful completion of the jobs.
Sagar
crystal_pup
Participant
Posts: 62
Joined: Thu Feb 08, 2007 6:01 am
Location: Pune

Post by crystal_pup »

You can use the orchadmin command to delete the temporary datasets.The command sysntax would be :-

../bin/orchadmin rm nameofthedataset
somesh2suma
Participant
Posts: 23
Joined: Wed Apr 08, 2009 5:28 am
Location: Bangalore

Post by somesh2suma »

hi

Even i have the same problem, but i want to put it in job control.
"../bin/orchadmin rm nameofthedataset"
canl this above command placed in job control or should we have to place in unix script.

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

Post by ray.wurlod »

You can place it job control. Use DSExecute() and specify both the commmand and the Data Set descriptor file as full pathnames.
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