Unzip in DS

urshit_1983 · Post by **urshit_1983** » Tue Jul 18, 2006 11:39 am

Can a file be unzipped in Datastage, installed on Client with OS=Windows? Is is possible without moving it to server, with OS=Unix?

Thanks

Krazykoolrohit · Post by **Krazykoolrohit** » Tue Jul 18, 2006 11:57 am

yes.
In sequqential stage properties, where you define the file path. you can give the command gunzip. this will be executed before the file is read.

You also need to check "stage uses filter commands" before you can enable the filter command input box.

ArndW · Post by **ArndW** » Tue Jul 18, 2006 12:03 pm

All DataStage job files are relative to the server and not the client. You can execute command-line unzip program a part of a sequential file stage, but it must be visible from the Server.

urshit_1983 · Post by **urshit_1983** » Tue Jul 18, 2006 12:05 pm

Thanks ArndW. That was my question. So first I need to FTP to Unix server then use unzip. Rite ?

ArndW · Post by **ArndW** » Tue Jul 18, 2006 12:11 pm

Sure, if you have the appropriate unzip program on UNIX, or else unzip it on the PC and FTP it over, or perhaps you might have software that lets you mount a NTFS network drive from your UNIX flavor.

The unzip or other preprocessing can be done as a call from your sequential file stage once you've got the file on your DataStage server system.

urshit_1983 · Post by **urshit_1983** » Tue Jul 18, 2006 12:14 pm

Thanks I got it. But I want to make this automated to unzip. Is there a way in Datastage?

DSguru2B · Post by **DSguru2B** » Tue Jul 18, 2006 12:21 pm

Ofcourse you can. Look at the filter option in the sequential file stage, or you can even get it done as a before job subroutine by ExecSH and typing your unzip command there.

urshit_1983 · Post by **urshit_1983** » Tue Jul 18, 2006 1:09 pm

So I have to write a UNIX script rite ? That means that I need to do FTP from Unix and act Unix as my Local machine and my PC as remote rite ? But then when I use FTP in unix what shall i write in Open to ?

ray.wurlod · Post by **ray.wurlod** » Tue Jul 18, 2006 6:29 pm

The word is "right".

A UNIX script rite is something too horrible to contemplate.

ArndW · Post by **ArndW** » Wed Jul 19, 2006 1:03 am

If you use the DataStage FTP stage and filter your unzip command into your sequential file stage you do not need to write any scripts.

Krazykoolrohit · Post by **Krazykoolrohit** » Wed Jul 19, 2006 8:08 am

Krazykoolrohit wrote:yes.
In sequqential stage properties, where you define the file path. you can give the command gunzip. this will be executed before the file is read.

You also need to check "stage uses filter commands" before you can enable the filter command input box.

thats what i said

No need to write a script. its just a command which can be passed and you may even zip it back if you have a output link from that sequential stage