Delete Dataset

atulgoel · Post by **atulgoel** » Mon Aug 24, 2009 10:55 pm

Hi,

Is there any way to delete multiple dataset?

We can delete dataset one by one using "Data Set Management", but how to delete multiple dataset in Datastage 8.x.

Thanks
Atul

ray.wurlod · Post by **ray.wurlod** » Mon Aug 24, 2009 11:12 pm

You can use the orchadmin command in a script or even with wildcard characters.

atulgoel · Post by **atulgoel** » Mon Aug 24, 2009 11:19 pm

Hi,

Thanks for the reply.

Can you please explain how to use orchadmin command to delete multiple dataset, because I am new to this.

Thanks
Atul

ray.wurlod · Post by **ray.wurlod** » Tue Aug 25, 2009 12:00 am

A Search of DSXchange would have saved you the trouble of waiting for this reply. Assuming that you have executed the dsenv script, your command search list (PATH environment variable) includes the DataStage parallel engine bin directory and have correctly set APT_CONFIG_FILE and APT_ORCHHOME, then the orchadmin command does most of the things that the GUI allows. To delete a Data Set, the syntax is orchadmin rm blah.ds, where blah.ds is the pathname of the control file of the Data Set in question.