RE: [sqr-users] Call System Using command

["Steve Cavill" <steve.cavill@infoclarity.com.au>]

So it's back to the original problem.  You need to get the command to work on 
your server where the sqr runs.
Which is not related to SQR
Are you trying to run a .bat file on server A from server B? 
That can't be done with windows.
You would need to use rexec or similar utility to runa script on a remote 
machine.
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: Wednesday, 15 November 2006 1:14 AM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] Call System Using command

Hi Steve,

Actually in .bat file there is a cd command to change the directory, so that 
the download data will go in that directory. Now on my
computer that directory is mapped. When I changed the cd command from 'cd 
download-all ' 
to say 'chdir /u c:/download-all' then the script works from a command prompt.

But when SQR runs on server, there is no mapping of this drive on server. In 
that case I cannot use the same 'chdir' command to
change the directory.  I cannot use 'net use' command to map the directory on 
the server, as I do not and cannot have the userid and
password for the server. I am not sure what I can use or even I can do this.

Thanks for all your help,
Anu


>From: "Steve Cavill" <steve.cavill@infoclarity.com.au>
>Reply-To: "This list is for discussion about the SQR database 
>reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
>To: "'This list is for discussion about the SQR database 
>reportinglanguagefrom Hyperion Solutions.'" <sqr-users@sqrug.org>
>Subject: RE: [sqr-users] Call System Using command
>Date: Fri, 10 Nov 2006 12:57:27 +1100
>
>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

_________________________________________________________________
Tried the new MSN Messenger? It's cool! Download now. 
http://messenger.msn.com/Download/Default.aspx?mkt=en-in


_______________________________________________
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