RE: RPG or SQL?

Steve,

Try adding something like this to your SQL:

With temptable as (SELECT DISTINCT ACCT, mod FROM *libl/mdpwrk WHERE
acct > 12806 ORDER BY ACCT, MOD)

Select yourfields from temptable join file with PO on join fields ...

This will create a temporary file with your 'level breaks' and join it
to your PO file or whatever you want.

I haven't been using with for very long so my syntax may not be correct
from memory.  Others on this list have more experience with it and other
flavors of temporary tables and may give you a better example or a
better way.

Rick

> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of
> steema@xxxxxxxxxxxxx
> Sent: Tuesday, May 02, 2006 9:21 AM
> To: RPG400-L@xxxxxxxxxxxx
> Subject: RPG or SQL?
>
> HI Perhaps I wasn't clear last time I was talking about SQL.
> In RPG I would do a Control Break on Acct & Model, then it
> would show me as many fields as needed.
> In SQL I do this:
> SELECT DISTINCT ACCT, mod FROM *libl/mdpwrk WHERE acct >
> 12806 ORDER BY ACCT, MOD.
>
> Because there are many acct/mod records but we are interested
> in only the one occurance.
>
> But we also want to see other information such as PO # to
> help locate the records.
>
> W/ the SQL it seems that I can only do a 'control break' on
> the exact fields that will make up the output. in this case,
> it seems as I need to write an RPG program for the Control
> Break feature?
>
> Steve

Privileged and Confidential.  This e-mail, and any attachments there to, is 
intended only for use by the addressee(s) named herein and may contain 
privileged or confidential information.  If you have received this e-mail in 
error, please notify me immediately by a return e-mail and delete this e-mail.  
You are hereby notified that any dissemination, distribution or copying of this 
e-mail and/or any attachments thereto, is strictly prohibited.