Loading a zipped File

Lotus26 · Post by **Lotus26** » Thu Feb 28, 2008 9:57 am

HI

I have a big file which comes from a source in zipped format . If I try to unzip , it is giving an error because of the space issues .

So with out unzipping the file , is there any way to read the file in datastage?

Thanks.

chulett · Post by **chulett** » Thu Feb 28, 2008 10:00 am

I guessing you could use the Filter option in the Sequential File stage to unzip the file to standard out and then consume the stream. No idea how much temp space, if any, that would still require.

ArndW · Post by **ArndW** » Thu Feb 28, 2008 10:05 am

As Craig has already pointed out, use the filter option in the sequential file stage. If your source file is "a.Z" then the filter option would read

Code: Select all

uncompress -c

and the compressed file is read and uncompressed in memory to the DataStage job.

Lotus26 · Post by **Lotus26** » Thu Feb 28, 2008 11:29 am

Thank you for your help . I used the gzip -cd option in the filter and it did worked fine .