[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
RE: [sqr-users] Call System Using command
- Subject: RE: [sqr-users] Call System Using command
- From: "the dragon" <ceprn@hotmail.com>
- Date: Tue, 07 Nov 2006 08:42:15 -0600
- Bcc:
- Delivery-date: Tue, 07 Nov 2006 09:44:54 -0500
- In-reply-to: <BAY110-F2138B877491CF16F8C68BAD0F20@phx.gbl>
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
why not give it the complete path, with the mapped drive?
peace,
clark 'the dragon' willis
PSA: Salary <> Slavery. If you earn a salary, your employer is renting your
services for 40 hours a week, not purchasing your soul. Your time is the
only real finite asset that you have, and once used it can never be
recovered, so don't waste it by giving it away.
I work to live; I don't live to work.
"Time is the coin of your life. It is the only coin you have, and only you
can determine how it will be spent. Be careful lest you let other people
spend it for you."
Carl Sandburg
(1878 - 1967)
It is impossible to defeat an ignorant man in argument.
William G. McAdoo
----Original Message Follows----
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>
>
>
>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
>
>-----Original Message-----
>
>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
_________________________________________________________________
Use your PC to make calls at very low rates
https://voiceoam.pcs.v2s.live.com/partnerredirect.aspx
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users