RE: [sqr-users] Using UNIX command thru SQR

[Dattatraya Shetty <datta_shetty@yahoo.com>]

Hi Yamuna,
    Just an addition to what paul has mentioned here. 
You can use the command as below that way lot of junk can be avoided. 

try the Program here and see if it works 

==== 
! You need to code the rest like Paul mentioned but here is a
suggestion for the Unix Command. 

let $command = 'ls -lts | tr -s " " | cut -d" " -f9 > /tmp/files.txt'  

then execute the command using system command and  inside the SQR
follow Pauls Instruction. 

=========================================== 

HTH 
Datta. 

--- Paul Hoyte <pi_hoyte@si-proservices.com> wrote:
> First, use the  call system command from within SQR to issue the UNIX
> command that will execute the ls -lts command.  Re-direct the output
> into a
> text file on the file system.  Then from within SQR open the text
> file and
> read the first 2 records which will contain the latest 2 files in the
> directory.  You will probably have to parse the file since it will
> contain a
> lot of extra information that you probably don't need. 
> 
> 
> Paul Hoyte 
> (248) 752-6970 Cell 
> (586) 421-9640 Fax 
> pa_hoyte@si-proservices.com (Email) 
> www.sharidionne.com (Web Site) 
> 
> 
> -----Original Message-----
> From: sqr-users-bounces+pi_hoyte=si-proservices.com@sqrug.org
> [mailto:sqr-users-bounces+pi_hoyte=si-proservices.com@sqrug.org] On
> Behalf
> Of yamuna_pandiyan@freddiemac.com
> Sent: Friday, March 25, 2005 3:50 PM
> To: sqr-users@sqrug.org
> Subject: [sqr-users] Using UNIX command thru SQR 
> 
> 
> 
> 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 want to read the most recent data file created in the data
> directory into
> the SQR program.
> 
> I use the following command on the Unix box to sort the most recent
> file
> 
>   >  ls -lts <filename>
> 
> I need some help with the code to read the most recent file from the
> data
> directory into the SQR program .
> 
> 
> Thanks,
> Yamuna
> 918-5127
> 
> 
> _______________________________________________
> 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
> 


                
__________________________________ 
Do you Yahoo!? 
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/ 

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