RE: [sqr-users] Call System Using command

["Knapp, Richard" <KnappR@umsystem.edu>]

If SQR is running on a unix box (server A?), the windows drive mappings
will do no good.  Also, even if the server is a windows machine, if the
drive mappings are not made on that machine, it will produce the error
you see.

If you can log on to the server, work out and test the paths to the
other machines involved.

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: Tuesday, November 07, 2006 8:31 AM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] Call System Using command

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

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