[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: [sqr-users] Call System to execute.bat file
- Subject: Re: [sqr-users] Call System to execute.bat file
- From: "Don Mellen" <donm@ontko.com>
- Date: Thu, 30 Aug 2007 10:42:08 -0400
- Delivery-date: Thu, 30 Aug 2007 10:44:28 -0400
- In-reply-to: <200708301401.ACM53033@colby.edu>
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
- References: <200708301401.ACM53033@colby.edu>
If you use "CALL SYSTEM" then the status returned is from the "SYSTEM" you
are "CALL"ing. So in your case, it's a windows/dos status
On 8/30/07, R. Neal Patterson <rnpatter@colby.edu> wrote:
>
> I'm interested in using CALL SYSTEM to run a .bat file from SQR.
>
> I was able to make the following work based on the the coding
> suggested earlier by K.M.Narayanan:
>
> LET $COMMAND = 'C:\WINDOWS\system32\cmd.exe /c DIR *.* > MyDirResults.txt'
> CALL SYSTEM USING $COMMAND #call_status wait
>
> However, the #call_status returns value 1 when I try the following
> (and the commands within MyBatFile.bat are not executed):
>
> LET $COMMAND = 'C:\WINDOWS\system32\cmd.exe /c MyBatFile.bat'
> CALL SYSTEM USING $COMMAND #call_status wait
>
> How can I get the above to work? Where can I find a list of the
> status code values and their meanings?
>
> Thanks,
> -Neal
>
> -------------------------------------------------------------------
> Neal Patterson, Sr. Programmer/Analyst
> College Relations Operations and Analysis, Colby College
> 4336 Mayflower Hill, Waterville, ME 04901-8843
> Phone: (207)859-4336 E-mail: rnpatter@colby.edu
> -------------------------------------------------------------------
>
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
>
--
-----------------------------------------------------------------------
Donald Mellen | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/
donm@ontko.com | "In the beginning, there was nothing, which exploded"
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users