RE: [sqr-users] Call System to execute.bat file

["Knapp, Richard" <KnappR@umsystem.edu>]

I've run batch files without invoking the command interpreter.  Just put
the full path into your call system command.

Richard Knapp
EAS - Data Warehouse Group
University of Missouri
615 Locust Street  #200
Columbia, MO 65201
573-882-8856
knappr@umsystem.edu


-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
Don Mellen
Sent: Thursday, August 30, 2007 9:42 AM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: Re: [sqr-users] Call System to execute.bat file

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

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users