SQL Statements embedded in RPG

[JFinney@xxxxxxxxxxx]

Hi All,

I've recently started to "get my hands dirty" with SQL on the '400 and am
battling to get my head around some issues.
Say, for instance, in traditional RPG logic + LF's, one would chain/reade
(loop) a logical and, for each record, go to
another loop and chain/reade based on a key (keeping it simple to start,
assume the unique key to be one field from the
original LF).

 What would the SQL statement look like to do the equivalent of what's just
been explained in the previous paragraph ?

Hope this question is clear enough (seems a little murky upon a re-read).
If anyone is unclear, please e-mail me and I'll
try to ask with a little more clarity.

Regards
John.


+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---