[sqr-users] Call SYSTEM command in SQR

[yamuna_pandiyan@freddiemac.com]

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