RE: [sqr-users] Call System Using command

["Anu Bagde" <anubagde@hotmail.com>]

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