Re: [sqr-users] Call SYSTEM command in SQR

[Dattatraya Shetty <datta_shetty@yahoo.com>]

Hi Yamuna,
    The Second part of the Problem is that FILEPREFIX may be an environment 
variable not defined? 
 
In the fist part the $ is missing for an environment variable. 
 
It would help if you let us know what is the excat command you are typing in at 
the command 
prompt. 
 
e.g 
 
$> ls -tls FMUBSOPT.DAT* > ${FILEPREFIX}Latestfile.dat 
is this what you are typing ? 
 
The fact that you are getting a file called Latestfile.dat tells me that the 
FILEPREFIX is not defined or you are not keying it correctly what is it ? 
 
HTH 
Datta. 
 
 

yamuna_pandiyan@freddiemac.com wrote:
I am using a program which needs to compare the current data with the
previous data file. the data files are created with date and time stamp.
This program runs once a week, and has to compare the previous weeks data
file to monitor the data changes.

I am using the following command on the Unix box to sort the most recent
file

let $file_list = '{FILEPREFIX}Latestfile.dat'

let $syscmd = '{FILEPREFIX}' || 'ls -lts SAMPLE.DAT >' || $file_list
call system using $syscmd #unix_status
if #unix_status != 0
stop quiet
end-if

The Latestfile.dat file is created in the data directory mentioned under
{FILEPREFIX}. But the file is empty. I would like to send the result of the
command
ls -lts FMUBSOPT.DAT* to the above file.
when I execute the above program in the unix server , I ge the following
error - {FILEPREFIX} : cannot execute, but a blank file in the name of
Latestfile.dat is created.

any help in greatly appreciated.

Thanks,
Yamuna
918-5127



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

                
---------------------------------
Do you Yahoo!?
 Yahoo! Sports -  Sign up for Fantasy Baseball.

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