[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: franck.masson2002@laposte.net
- Date: Thu, 30 Aug 2007 21:49:12 +0200 (CEST)
- Delivery-date: Thu, 30 Aug 2007 15:52:04 -0400
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
as you are using this command
LET $COMMAND = 'C:\WINDOWS\system32\cmd.exe /c MyBatFile.bat'
windows do not know where to find MyBatFile.bat exept if you have modified your
PATH variable to include the directory of this file.
you should specify the full path of your bat file
franck,
> Message du 30/08/07 16:04
> De : "R. Neal Patterson"
> A : sqr-users@sqrug.org
> Copie à :
> Objet : [sqr-users] Call System to execute.bat file
>
> 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
>
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users