Page 1 of 1

How to Delete Dataset in Datastage parallel jobs

Posted: Wed May 13, 2009 12:14 am
by nandela.sudheer
How to Delete Dataset in Datastage parallel jobs

Posted: Wed May 13, 2009 12:32 am
by ray.wurlod
Overwriting a Data Set first deletes it. You can see this happening in the score. You should not need to delete a Data Set from within a parallel job otherwise than this.

If you want to delete a Data Set from, say, a job sequence or the command line on the server, then you use the orchadmin command with appropriate option (rm or delete).

You could have discovered this more quickly with a Search of DSXchange.

Posted: Wed May 13, 2009 6:46 am
by nagarjuna
It can be deleted by dataset management utility or orchadmin .

Posted: Wed May 13, 2009 8:08 am
by sureshreddy2009
use unix command orachadmin datasetname