[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: [sqr-users] How To Unzip files using Sqr
- Subject: Re: [sqr-users] How To Unzip files using Sqr
- From: "chandra reddy" <chandra.bhumi@gmail.com>
- Date: Fri, 7 Sep 2007 20:10:46 +0530
- Delivery-date: Fri, 07 Sep 2007 10:43:07 -0400
- Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta;h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;bh=0X9eTORAS/hiKl5Spueh09jMT/U86bYoz/yyFBmMANQ=;b=CyqmW/ICtskN64lwqJtLeEvFs8OIpX6tY9EphKi3NmY3r8cbOggSks/1K9LAaP45CS+j/E0AxhQhkwx+DNAaNF/+BrToP99+Z92d06X0+Hp5WggmEgJvusXllaG+UJb7ro6uzKmSrrz8EgG2KVKwvSqFcAwruKLelqWx9E6YUDw=
- Domainkey-signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;b=AeFcCodTx4J0zl4fMKLJOnfLGmert/+uxYKi4YJDNx6ysIsOfGQ2+f6K0jPe282tgjThvsEIekzxwLo3t0urUUQvXu4l5qgBueKsMNau8AILCCCtyxfncTtu0BDArcGK/YZ6VXlfNOvHTPG1PWkG8hVLGhdhj2L0AW+Qo+/lpk0=
- In-reply-to: <819855.17832.qm@web36815.mail.mud.yahoo.com>
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
- References: <02839363BA87B447B34ECE391D0DC654782189@ex01.sjcity.net><819855.17832.qm@web36815.mail.mud.yahoo.com>
Hi,
let $Zip_Exe_Path = '\C$\Progra~1\WinZip\WINZIP32.EXE'
let $syscmd = 'cmd /c "c:"'
CALL SYSTEM USING $syscmd #stat WAIT
let $syscmd = $Zip_Exe_Path||' -min -a -en "'||$Zipfilepath_Path||'.zip"
"'||filetobezipped_path||'.dat"'
CALL SYSTEM USING $syscmd #stat WAIT
if #stat = 0
show 'Zip successful...'
else
let $Zip_Error = 'Error ' || to_char(#stat) || ' attempting Zip...'
show $Zip_Error
end-if
-------------------
U can try this code
On 9/7/07, kuldeep vaidya <kuldeep_vaidya@yahoo.com> wrote:
>
> Hi,
> I am trying to unzip files using sqr. I have following code in my sqr
>
> #define UnZipCmd 'e:\program files\winzip\wzunzip -o'
> let $command = {UnZipCmd}
> let $parms = $ZipFile || ' ' || $PayFile
> let $commandline = $command || ' ' || $parms
> call system using $commandline #sstatus wait
>
> where $ZipFile is the path where my zip file is present and $PayFile is
> the path where I want to unzip the files.
>
> Is wzunzip is exe file which I need to unzip the file because I can not
> see this file in my winzip folder i.e in 'e:\program files\winzip'
>
> Please let me if you have any suggestions on it.
>
> Thanks a Lot
> Kuldeep
>
>
> ---------------------------------
> Ready for the edge of your seat? Check out tonight's top picks on Yahoo!
> TV.
>
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
>
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users