extracting a zip file from a job

vsi · Post by **vsi** » Sun Apr 02, 2006 7:29 pm

Hi,

i have a zip file which will be created in a folder.
i need to watch for the zip file.
once,this zip file is existing in a folder, extract the files to a particular folder..
these extracted files are necessary for some other operations..

eg:
lets say i have folder called "Inbox"
at some period of time, a zip file is created in the folder "Inbox".

I need to watch for this zip file in "inbox" folder,extract files to some other folder.
all these are done before running a job.

my server is running on Unix.datastage client tools are on Windows.

i apologize for any spelling mistakes

Thanks
vsi

ray.wurlod · Post by **ray.wurlod** » Sun Apr 02, 2006 8:08 pm

This will be quite a tricky exercise if DataStage really is on a UNIX server. Do you use samba or some similar protocol to make Windows folders visible to UNIX? Unless this is the case, I doubt that DataStage-on-UNIX is the correct tool for this task.

rleishman · Post by **rleishman** » Sun Apr 02, 2006 9:36 pm

Apols to Ray if he covered it lower in his reply, but you can get Zip and Unzip for Unix. I have used them on both Tru64 and Linux, I'd be surprised if they're not available for (some) other platforms as well - google it.

ray.wurlod · Post by **ray.wurlod** » Sun Apr 02, 2006 11:42 pm

More concerned for now how to use a Wait For File activity on UNIX to await the appearance of a file in a Windows folder, which it appears is what vsi wants to do.

rleishman · Post by **rleishman** » Mon Apr 03, 2006 4:24 pm

Mmmm, yes

. I really should read through to the end of the OP's post. "client tools are on Windows" is a bit inconclusive, but I think you're right to bet that the OP wants to wait on a remote file.

vsi · Post by **vsi** » Wed Apr 05, 2006 3:58 pm

Yes,

DataStage Designer,Manager,Director,Admin are running on
Windows 2k Prof.

The flat files exist on Unix Server.
normally i access the files using Putty.

Plz know me,if you have anzy questions..

Thanks
vsi

rleishman · Post by **rleishman** » Wed Apr 05, 2006 4:29 pm

By "flat files", so you mean the Zip Files? If the Zip files are on Unix, try to source a WinZip compatible version of Zip compatible for your flavour of Unix - use Google.

ray.wurlod · Post by **ray.wurlod** » Wed Apr 05, 2006 4:32 pm

I'm not aware that any of the putty command line utilities gives you a Wait For File capability. You could, I guess, script a ptcp command to attempt to copy the file, and only proceed if it succeeds, otherwise sleep for a while and try again, but it's not a pretty solution.

vsi · Post by **vsi** » Wed Apr 05, 2006 6:07 pm

can i do all these stuff with in a job and create a scheduler..
i can use waitforfile activity in the job,
i can unzip the file and i can archive the zip file.

but i need a right approach for these...

ray.wurlod · Post by **ray.wurlod** » Wed Apr 05, 2006 11:50 pm

HOW can you use a Wait For File activity?

That's been my point. Unless you can "see" the Windows folder where the zip file will arrive from your UNIX machine on which DataStage is running, you will wait in vain.

kumar_s · Post by **kumar_s** » Thu Apr 06, 2006 12:50 am

So rather than beliveing in Datastge, you may start writing your own logic using routine or any bat file to wait for file and extract the same.

vsi · Post by **vsi** » Thu Apr 06, 2006 11:23 am

ray.wurlod wrote:HOW can you use a Wait For File activity?

That's been my point. Unless you can "see" the Windows folder where the zip file will arrive from your UNIX machine on which DataStage is running, you will wait in vain.

Hi ray,

FYI,

from Datastage Designer,
in sequence, WaitForFile activity,
when i click "Browse for File",i am able to see all the folders
which are existing in UNIX system.

ray.wurlod · Post by **ray.wurlod** » Thu Apr 06, 2006 4:24 pm

...and the zip file will arrive in a UNIX directory?

vsi · Post by **vsi** » Thu Apr 06, 2006 4:30 pm

ray.wurlod wrote:...and the zip file will arrive in a UNIX directory?

yes,
somehow the zip file is in Unix Directory.

ray.wurlod · Post by **ray.wurlod** » Thu Apr 06, 2006 4:44 pm

In that case you CAN use a Wait For File activity. Then an Execute Command activity to run a UNIX-based unzip or - alternately - use the same command as a filter in a Sequential File stage.