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

[yamuna_pandiyan@freddiemac.com]

The data files contains around 5000 records

Thanks,
Yamuna
918-5127


                                                                           
             "Knapp, Richard"                                              
             <KnappR@umsystem.                                             
             edu>                                                       To 
                                       "This list is for discussion about  
  Sent by :                            the SQR database reportinglanguage  
  sqr-users-bounces+yamuna_pan         from Hyperion Solutions."           
  diyan=freddiemac.com@sqrug.o         <sqr-users@sqrug.org>               
  rg                                                                    cc 
                                                                           
                                                                   Subject 
             03/25/2005 04:06          RE: [sqr-users] Using UNIX command  
             PM                        thru SQR                            
                                                                           
                                                                           
             Please respond to                                             
               "This list is                                               
               for discussion                                              
               about the SQR                                               
                  database                                                 
                 reporting                                                 
               language from                                               
                  Hyperion                                                 
                Solutions."                                                
              <sqr-users@sqrug                                             
                   .org>                                                   
                                                                           
                                                                           





How much data?  What does it look like?

Richard Knapp
Database Programmer/Analyst
Institutional Research and Planning
University of Missouri System
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
yamuna_pandiyan@freddiemac.com
Sent: Friday, March 25, 2005 2: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




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