How to Delete Dataset in Datastage parallel jobs

nandela.sudheer · Post by **nandela.sudheer** » Wed May 13, 2009 12:14 am

ray.wurlod · Post by **ray.wurlod** » Wed May 13, 2009 12:32 am

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.

nagarjuna · Post by **nagarjuna** » Wed May 13, 2009 6:46 am

It can be deleted by dataset management utility or orchadmin .

sureshreddy2009 · Post by **sureshreddy2009** » Wed May 13, 2009 8:08 am

use unix command orachadmin datasetname