Unzip in DS
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 73
- Joined: Wed Jun 28, 2006 3:27 pm
- Location: NJ
Unzip in DS
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
Thanks
"Nobody is expert in Everything,
But Everybody is expert in Something."
But Everybody is expert in Something."
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 73
- Joined: Wed Jun 28, 2006 3:27 pm
- Location: NJ
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.
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 73
- Joined: Wed Jun 28, 2006 3:27 pm
- Location: NJ
-
- Participant
- Posts: 73
- Joined: Wed Jun 28, 2006 3:27 pm
- Location: NJ
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio
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 stageKrazykoolrohit 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.