MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » March 2008

Re: Should I be using SQL?



fixed

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
>





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact