Page 1 of 1
How to delete a dataset file which is in unix server
Posted: Wed Aug 11, 2010 2:59 am
by jpradeep.net
to delete the datafile and descriptor file belongs to a dataset which is in a unix server
Posted: Wed Aug 11, 2010 3:18 am
by nitkuar
In datastage 8x version, we can delete datasets(descriptor and their corresponding data files) using orchadmin del <dataset_name> ...not sure about version 7x...but u can give a shot...
Thanks
Nitin
Re: How to delete a dataset file which is in unix server
Posted: Wed Aug 11, 2010 3:20 am
by sultan@cts
jpradeep.net wrote:to delete the datafile and descriptor file belongs to a dataset which is in a unix server
Orchadmin is a command line utility provided by datastage to research on data sets.
search for the Orchadmin commadns to delete the dataset.
other wise you can delete the dataset from dstaset management utility also, which you can find in Datastage designer tool-->dataset management utility.
Re: How to delete a dataset file which is in unix server
Posted: Wed Aug 11, 2010 3:29 am
by jpradeep.net
sultan@cts wrote:jpradeep.net wrote:to delete the datafile and descriptor file belongs to a dataset which is in a unix server
Orchadmin is a command line utility provided by datastage to research on data sets.
search for the Orchadmin commadns to delete the dataset.
other wise you can delete the dataset from dstaset management utility also, which you can find in Datastage designer tool-->dataset managenet utility.
Thank you verymuch
Posted: Wed Aug 11, 2010 6:15 am
by chulett
nitkuar wrote:In datastage 8x version, we can delete datasets(descriptor and their corresponding data files) using orchadmin del <dataset_name> ...not sure about version 7x... but u can give a shot...
It's there in 7.x as well. And it's "you", not "u" please.
Posted: Wed Aug 11, 2010 6:21 am
by srinivas.g
use the below command
orchadmin rm "datastet.ds"
Posted: Wed Aug 11, 2010 7:20 pm
by ray.wurlod
Amazed that no-one mentioned the Data Set Management utility available from the Tools menu in Designer client. Simply select the Data Set and click the Delete tool.
Posted: Thu Aug 12, 2010 3:24 am
by priyadarshikunal
ray.wurlod wrote:Amazed that no-one mentioned the Data Set Management utility
Its there
sultan@cts wrote:
other wise you can delete the dataset from dstaset management utility also, which you can find in Datastage designer tool-->dataset managenet utility.
Posted: Thu Aug 12, 2010 6:42 am
by chulett
Ray kind of... skims... sometimes.
Posted: Thu Aug 12, 2010 9:03 am
by rahulverma
The unix rm utility cannot be used to delete the datasets. The orchadmin delete or rm command should be used to delete one or more persistent data sets.
Posted: Thu Aug 12, 2010 9:12 am
by priyadarshikunal
rahulverma wrote:The unix rm utility cannot be used to delete the datasets.
Instead of "can not", I would use "should not". rm command can be used if you understand what you need to delete and from where. However I won't suggest any one to use that as there are more sophesticated and cleaner utilities/tools to do the same like orchadmin and dataset management utility.