RE: READE on a file selected by user

[David FOXWELL <David.FOXWELL@xxxxxxxxx>]

Thanks all,

We often end up debating when sql has an advantage over rla but I don't ever recall this being put forward as one of them.
Surely as soon as one knows that in an application a user is going to effectively select a set of records himself then one should be thinking SQL from the start?

I know of one application that first showed clients selected by name. Then they added a number. Then maiden name followed and company name. The code is really ugly without sql.

> -----Message d'origine-----
> De : rpg400-l-bounces@xxxxxxxxxxxx 
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx] De la part de Jerry C. Adams
> Envoyé : jeudi 24 février 2011 14:27
> À : 'RPG programming on the IBM i / System i'
> Objet : RE: READE on a file selected by user
>
> Here, here.  I admit that I usually forget about this (using 
> embedded SQL).
> But I recall one inquiry a few years back where everybody and 
> their second cousins wanted different selections and 
> sequences.  I wound up writing a selector panel where they 
> could put in just about anything they wanted (well, within 
> reason, as defined by me) and sort (order by) whatever.
> Building the SQL wasn't too bad.
>
> Jerry C. Adams
> IBM i Programmer/Analyst
> I found a delivery in my flaw. -Don Quisenberry
> --
> A&K Wholesale
> Murfreesboro, TN
> 615-867-5070
>
>
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx 
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
> On Behalf Of Helge Bichel
> Sent: Thursday, February 24, 2011 6:45 AM
> To: 'RPG programming on the IBM i / System i'
> Subject: RE: READE on a file selected by user
>
> Hi David.
>
> It's better and much more flexible using SQL for this task.
>
> I know starting with dynamic SQL constructing the SQL with 
> Select, Order By etc. 
> and implementing the processing of Declare, Open, Fetch etc. 
> can be a challenge, but done once I believe you would never 
> go back using various SETLL, READE processing.
>
> Brgds
> Helge
>   
>
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx 
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
 
> Sent: Thursday, February 24, 2011 1:01 PM
> To: RPG programming on the IBM i / System i
> Subject: READE on a file selected by user
>
> Hi,
>
> I'm sure someone must have already run into this problem :