[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] Call System to execute.bat file
- Subject: [sqr-users] Call System to execute.bat file
- From: "R. Neal Patterson" <rnpatter@colby.edu>
- Date: Thu, 30 Aug 2007 10:01:39 -0400
- Delivery-date: Thu, 30 Aug 2007 10:04:16 -0400
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
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