Re: Should I be using SQL?

[Mike <koldark@xxxxxxxxx>]

Just like many things, there is no wrong way. I use SQL to get the core data
into my report then read/chain any additional files needed.

On Fri, Mar 21, 2008 at 11:18 AM, Tim Gornall <tgornall@xxxxxxxxxx> 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
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.