[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 Using command
- Subject: RE: [sqr-users] Call System Using command
- From: "Steve Cavill" <steve.cavill@infoclarity.com.au>
- Date: Fri, 10 Nov 2006 12:57:27 +1100
- Delivery-date: Thu, 09 Nov 2006 21:03:12 -0500
- In-reply-to: <BAY110-F34C48A932F30395718F116D0FE0@phx.gbl>
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
- Thread-index: AccB6sRC2vELrGoLSVK25SbZubQZNQCgE0Uw
Does the command work from a command prompt? That's the first step.
Once you get it working from a comamnd prompt then calling it from sqr should
be easy.
Steve.
-----Original Message-----
From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org
[mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org] On Behalf
Of Anu Bagde
Sent: Saturday, 4 November 2006 6:44 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Call System Using command
Hello all,
I am trying to use call system to execute a .dat file located on a different
server than where the SQR's are located. Operating
system on both the servers is Windows NT. I am initializing the variable named
$script_file with the actual fine name with complete
path. Then I use the following code to actually execute the .dat file:
let $command = getenv('COMSPEC')||' /c "' || $script_file || '"'
call system using $command #status WAIT
show 'Running command: ' $command ' Return Status: ' #status
My return status is 1. Can anyone help me understand this and solve this
problem? If this is not possible can any one help me find
another way to execute the .dat file, every day at 7pm?
Thanks in advance,
Anu
_________________________________________________________________
One and only Ash. Find out all about her. Only on MSN Search
http://server1.msn.co.in/profile/aishwarya.asp
_______________________________________________
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