Zip a file

basu.ds · Post by **basu.ds** » Tue May 26, 2009 4:48 am

Hi ,
Can any one help me on how to zip a csv file using datastage .i tried search in the forum but i did not find enough information .my requirement is that i have a file .i have to zip that file by job.

Thanks in advance,

ArndW · Post by **ArndW** » Tue May 26, 2009 6:18 am

You can do it easily from an after-job call. Just do an ExecSH and pass the ZIP command to the command line. If you are using WinZip you will need to download their command line extension.

chulett · Post by **chulett** » Tue May 26, 2009 6:25 am

In other words, you'll need something executable from the command line of your O/S for DataStage to initiate the zip. The registered version of WinZip has that as an option, other tools exist as well.

basu.ds · Post by **basu.ds** » Tue May 26, 2009 10:36 pm

Thanks a lot for replies ,
I don't have any zip software installed in my windows system.i tried dos command but it is not working

command zip filename.csv
i tried zip filename.zip also
both are not working any idea please help me

Thanks in advance,

ArndW · Post by **ArndW** » Wed May 27, 2009 1:00 am

The first thing you need to do is to get a DOS command working; once that functions you can get it working from DataStage. There are several compression packages available, from the old PKZIP to the UNIX type gzip, compress and bzip. Which one you decide to use is up to your site.

PhilHibbs · Post by **PhilHibbs** » Wed May 27, 2009 4:07 am

7-Zip is good.
http://www.7-zip.org/
Or Info-zip.
http://www.info-zip.org/

qutesanju · Post by **qutesanju** » Wed May 27, 2009 5:15 am

I also occured same problem.but i tried it with moving the files from source location to destination TEMP location through a BATCH file DOS command.

chulett · Post by **chulett** » Wed May 27, 2009 6:38 am

basu.ds wrote:I don't have any zip software installed in my windows system

First step - get some. All else is for naught otherwise.

basu.ds · Post by **basu.ds** » Thu May 28, 2009 6:52 am

Thanks for all ,
i have installed winrar on mechine
I am able to zip a file from command line usind dos command
but i am not able to zip using DataStage by using same command
then i tried create a batch file then i ran working fine from me but when i am using same batch file from datastage not working .my winrar installed in c drive but my datastage installed in d drive ,
so how can i acieve this
please any one suggest me on this

Thanks in advance,

chulett · Post by **chulett** » Thu May 28, 2009 6:56 am

basu.ds wrote:I am able to zip a file from command line usind dos command but i am not able to zip using DataStage by using same command

[sigh]

Why not? What syntax did you use and happens when you use it, what error(s) do you get?

Perhaps something like this will help in absense of the above information.

ArndW · Post by **ArndW** » Thu May 28, 2009 7:03 am

Craig - if you print out the post and hold the sheet of paper to the top of your head, you should be able to use digital osmosis and _know_ what the error message is. I, on the other, hand am going to have to wait for a description of the error message from basu.ds.

chulett · Post by **chulett** » Thu May 28, 2009 7:28 am

I believe I too shall wait.

qutesanju · Post by **qutesanju** » Thu May 28, 2009 7:59 am

Could you please share the DOS command ti zip and unzip..thru WINRAR?

chulett wrote:
basu.ds wrote:I am able to zip a file from command line usind dos command but i am not able to zip using DataStage by using same command
[sigh]

Why not? What syntax did you use and happens when you use it, what error(s) do you get?

Perhaps something like this will help in absense of the above information.

chulett · Post by **chulett** » Thu May 28, 2009 8:21 am

Click the link and all shall be revealed! [poof]

qutesanju · Post by **qutesanju** » Thu May 28, 2009 8:21 am

@Chulette......the link you shared is useful for EXTRACTING the RAR file....if you have can you pls share same info how to ZIP the file thru WINRAR from command prompt...............

Perhaps something like this will help in absense of the above information.[/quote]