RE: [sqr-users] Call System Using command

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

Hi Richard,

I could find the error in my script. It is a vendor delivered script and one 
of the command is to change the directory. I am running the sqr on say 
server A, .dat file is on remote server, say B and the directory to which 
the script is cd to is on remote server like, b:\download-all. I am getting 
an error when I run the command from command prompt that:

The system cannot find the path specified.
"downloads-all" directory cannot be found from the current directory.

Is there a way to actually change the directory?

Many thanks for your help,
Anu

>From: "Knapp, Richard" <KnappR@umsystem.edu>
>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 reportinglanguage 
>fromHyperion Solutions." <sqr-users@sqrug.org>
>Subject: RE: [sqr-users] Call System Using command
>Date: Mon, 6 Nov 2006 15:42:43 -0600
>
>
>The 1 usually indicates there is a syntax error.  Print out your command
>string and try it from a command prompt to get more info.
>
>Richard Knapp
>AITS - Reporting
>University of Missouri
>Locust Street Building
>Columbia, MO 65201
>573-882-8856
>knappr@umsystem.edu
>
>
>-----Original Message-----
>From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
>[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
>Anu Bagde
>Sent: Friday, November 03, 2006 1:44 PM
>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

_________________________________________________________________
Shah Rukh fan? Know all about the Baadshah of Bollywood. On MSN Search 
http://server1.msn.co.in/profile/shahrukh.asp


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users