Hello,
We have a requirement to load the dataset into a text file, archive the text file and delete the datasets due to the space constraints. We thought of loading the data from dataset to a text file through orchadmin utilities.
So, can anyone suggest if this is a good approach to use the orchadmin utility or to use a datastage job itself?
Note: We have many datasets each with different metadata and the text file will be used to load the data back to the datasets if needed.
Loading data from datasets to text file
Moderators: chulett, rschirm, roy
Loading data from datasets to text file
Thanks and Regards!!
dspxlearn
dspxlearn
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I would write a generic job to do the dataset -> text transfer. The job would declare no columns at all and use RCP, parameterizing the dataset file name and the output file. In the after-job routine I would call the shell command "orchadmin rm {path-and-name of dataset}" to delete the dataset.
If the text files are for archival, I would add a filter to your output sequential file such as "gzip -" to compress the archive while writing.
If the text files are for archival, I would add a filter to your output sequential file such as "gzip -" to compress the archive while writing.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>