RE: [sqr-users] Call System Using command

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

Rexec is a command that lets you execute commmands on a remote host.
In simple terms, you can only execute commabds on a local machine.
There is  no way to execute a command on a remote machine in windows.
Various ftp and tcpip utilities can allow you to logon to a remote host and 
execute commands there.
Look up rexec on google.
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, 18 November 2006 1:16 AM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] Call System Using command

Hi Steve,

I thought so too. But was not sure so I posted this message. I am not aware of 
rexec utility, may be I could use 'at' command on the
server where I have .bat file and where I want to download the data.

Thanks for all you 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, 17 Nov 2006 22:23:21 +1100
>
>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

_________________________________________________________________
Spice up your IM conversations. New, colorful and animated emoticons. Get 
chatting! http://server1.msn.co.in/SP05/emoticons/


_______________________________________________
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