DSXchange

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

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?

Yup!

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.

Gosh, almost word for word the answer I was going to give!

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

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.

Vitali.

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.