re: RPG or SQL?

You could use a SQL Cursor with a FETCH loop then check for a change in 
Acct & Model.  Control break logic requires you to read every record
and with SQL a FETCH loop also reads every record, you just dont
get an L1 indicator with SQL.

Frank Kolmann

>date: Tue, 2 May 2006 08:21:06 -0600 (MDT)
>from: steema@xxxxxxxxxxxxx
>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