Hi,
We delete flat files by just creating a BAT file which is called from the Execute Command Activity in the Sequence to do the cleanup. These days we are using Datasets, And since Datasets have descriptors and data files............. We can't just delete them from the target directory............
Is there a BATCH program through which we can delete the datasets......
Thank you.
BATCH file to delete DATASETS
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 467
- Joined: Tue Mar 20, 2007 6:36 am
- Location: Chennai
- Contact:
BATCH file to delete DATASETS
Minhajuddin
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
-
- Participant
- Posts: 467
- Joined: Tue Mar 20, 2007 6:36 am
- Location: Chennai
- Contact:
Thanks for the replies
My OS is a Windows Server 2003.
Do these BATCH files run on it?
My OS is a Windows Server 2003.
Do these BATCH files run on it?
Minhajuddin
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
There is no ready-made BATch file to do this, the posters have just supplied the raw command that will clean up a dataset and you will have to write an appropriate file.
If you have orphaned datasets, i.e. where someone has deleted the descriptor file without using orchadmin rm, you can look at this post that illustrates how to go about finding and removing orphaned datasets. Perhaps that can aid you in writing your own; the 'magic' command is part of the MKS toolkit or other similar tools that give you UNIX commands on Windows.
If you have orphaned datasets, i.e. where someone has deleted the descriptor file without using orchadmin rm, you can look at this post that illustrates how to go about finding and removing orphaned datasets. Perhaps that can aid you in writing your own; the 'magic' command is part of the MKS toolkit or other similar tools that give you UNIX commands on Windows.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 137
- Joined: Sun Jan 07, 2007 11:17 pm
- Location: VISAKHAPATNAM
Re: BATCH file to delete DATASETS
Hi,
could u please tell me how to use the dataset file....
is that used the same way as a sequential file....in parallel datastage..
thanku..
could u please tell me how to use the dataset file....
is that used the same way as a sequential file....in parallel datastage..
thanku..
Shivaranjani
Re: BATCH file to delete DATASETS
But u need to save the dataset file name with .ds ext.
It has the control file inside it
It has the control file inside it
G SHIVARANJANI wrote:Hi,
could u please tell me how to use the dataset file....
is that used the same way as a sequential file....in parallel datastage..
thanku..
DataSet files do not need to be named with a ".ds" extension, they can have any name.
DataStage PX uses DataSets as faster, more efficient storage than sequential files.
DataStage PX uses DataSets as faster, more efficient storage than sequential files.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>