How to use .zip file in DataStage

[itsgops]

Hi,

I have a file in .zip format in unix directory. I want to use this .zip file and get the source file and use the same file in DataStage.

File details: cust.zip. This cust file contains 3 columns like, cust_no, cust_name and salary.

May I know how to access this file and which stage is suitable for this. I have tried through Expand Stage but it must have single input link.

Let me know anybody aware of this concept...

Thanks in Advance
Gops

[nagarjuna]

i think if the file is zipped in a windows environment there is no way to unzip in unix .If its zipped using gzip or compress then you can go for before job routine or external filter .

[sanjay]

Hi

you can use Expand Stage which will unzip the file same like unzip comand in unix create a common job for that then use the source file in job

Thanks
Sanjay

Hi,

I have a file in .zip format in unix directory. I want to use this .zip file and get the source file and use the same file in DataStage.

File details: cust.zip. This cust file contains 3 columns like, cust_no, cust_name and salary.

May I know how to access this file and which stage is suitable for this. I have tried through Expand Stage but it must have single input link.

Let me know anybody aware of this concept...

Thanks in Advance
Gops