Re: Should I be using SQL?

[JDHorn@xxxxxxxxxxxxxx]

   an additional thought
    
   If you are converting old programs using level breaks, you can define the
   input file in your report program as a "special" file and feed the data
   using an sqlrpgle program.  the old level break programs can use sql to
   select and retrieve the data even if they are so old that the data is
   internally defined (if something has been working for 15  or 20 years it
   may not need fixing).  usually only 1 or 2 lines in the original program
   need to be changed. 
    
   if you want more info on this  google  - special files can do it all - 2
   articles by ted holt.
    
   Jim Horn 

     Tim Gornall wrote:
     > There appears to be much SQL talent on this list, and I'm thinking I
     may be
     > way behind the times.  So here's a "how are you guys doing it"
     question.  
     > A typical example:  A request comes in for a new report.  It will
     require
     > the user to enter some selection data (let's say from and to dates),
     then
     > process a bunch of records within RPG.  I'm still using open query
     files,
     > record select logic in RPG, etc.  Are some of you using SQL to do
     this, is
     > it a better way, or just different?  Would anyone like to share
     example code
     > of a clean lean application using SQL?  
     >
     > Thanks, Tim
     >