Hi,
Is there any command line utility or utility provided by Data Stage which can convert Data Sets to Sequential files?
Also wanted to know, which occupies more space Data Sets or Sequential files?
Appreciate if anybody can help me in this.
Thanks & Regards
Pinkesh
Converting Data Set to sequential file
Moderators: chulett, rschirm, roy
Re: Converting Data Set to sequential file
Yup!pkothana wrote:Is there any command line utility or utility provided by Data Stage which can convert Data Sets to Sequential files?
Also wanted to know, which occupies more space Data Sets or Sequential files?
dsjob -project RunMe -job ConvertDataSet -param input -param output
(oh yeah, you would need to create a job "ConvertDataSet" in a project "RunMe" that have a Dataset stage ---> sequential file output. But then we'll have to deal with the different column formats. Hmm. Now that is the first valid use of Column Propagation!)
And sequential files should generally be slightly smaller than datasets.
-T.J.
Last edited by Teej on Wed Dec 10, 2003 10:39 am, edited 1 time in total.
Developer of DataStage Parallel Engine (Orchestrate).
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Converting Data Set to sequential file
Yes, there is such a utility in DataStage. It's called orchadmin and is located in $APT_ORCHHOME/bin. orchadmin does many usefull things besides dumping datasets. Type orchadmin -help for usage information.pkothana wrote:Hi,
Is there any command line utility or utility provided by Data Stage which can convert Data Sets to Sequential files?
Also wanted to know, which occupies more space Data Sets or Sequential files?
Appreciate if anybody can help me in this.
Thanks & Regards
Pinkesh
Vitali.
Re: Converting Data Set to sequential file
vzoubov wrote:Yes, there is such a utility in DataStage. It's called orchadmin and is located in $APT_ORCHHOME/bin.
Uh... yeah, I knew that. *whistles innocently as he furiously type in the commands and start researching ... somethine else.*
-T.J.
Developer of DataStage Parallel Engine (Orchestrate).