RE: [sqr-users] Call System Using command

["Bambach, Tom" <TBambach@genchemcorp.com>]

Maybe the " character is the problem, try 

let $command = getenv('COMSPEC')||' /c ' || chr(34) || $script_file ||
chr(34)
instead of 
let $command = getenv('COMSPEC')||' /c "' || $script_file || '"'


-----Original Message-----
From: Knapp, Richard [mailto:KnappR@umsystem.edu] 
Sent: Monday, November 06, 2006 4:43 PM
To: This list is for discussion about the SQR database reportinglanguage
from Hyperion Solutions.
Subject: RE: [sqr-users] Call System Using command


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