Re: RPG or SQL?

Max(PO) it didn't like. There should be no mult. po's. there would be mult.
models per PO tho. I do want to stay w/ this until it is resolved rather
than quit and do the easy RPG Control Break.

> Are there multiple PO's per ACCT, MOD or just one?  If just one, then
> cheat:
> SELECT DISTINCT ACCT, mod, max(ponumber)
> FROM *libl/mdpwrk
> WHERE acct > 12806
> ORDER BY ACCT, MOD
>
>
> Rob Berendt
> --
> Group Dekko Services, LLC
> Dept 01.073
> PO Box 2000
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
>
>
>
>
>
> steema@xxxxxxxxxxxxx
> Sent by: rpg400-l-bounces@xxxxxxxxxxxx
> 05/02/2006 10:21 AM
> Please respond to
> RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
>
>
> To
> RPG400-L@xxxxxxxxxxxx
> cc
>
> 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
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>