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

["Knapp, Richard" <KnappR@umsystem.edu>]

Small enough to palce the data from the first file in an array and then
look up (pass through the array) for each row in the second file.

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 3:10 PM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: RE: [sqr-users] Using UNIX command thru SQR

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

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