Re: a need for speed

Lim,

Yes, it's similar, but QRY400 is less strict than SQL (you can break
on fields that you aren't sorting by).

The query would work, but you would still be stuck with the same "read
every record" performance issues inherent in the RPG cycle and level
break solution.

Rick

On 8/19/05, Lim Hock-Chai <Lim.Hock-Chai@xxxxxxxxxxxxxxx> wrote:
> this is similar to the sql that Rick sent earlier.  It probably would not 
> give me the result I wanted.  Below is an example of detail record and what 
> the result needs to be:
> 
> Detail record
>  601         123       0001     JSN
>  601         123       0002     JSN
>  601         123       0003     JSN
>  601         123       0004       JSN
>  601         123       0006     BTD
>  601         123       0010     BTD
>  601         123       0011     JSN
>  601         123       0030     BTD
>  601         123       0044     BTD
>  601         123       0091     JSN
>  601         123       0092     JSN
> 
> The result needs to be:
>  601         123       BTD      0006 - 10
>  601         123       BTD      0030 - 44
> 
>  601         123       JSN      0001 - 04
>  601         123       JSN    0011 - 11
>  601         123       JSN      0091 - 92
> 
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Paul Morgan
> Sent: Friday, August 19, 2005 10:18 AM
> To: rpg400-l@xxxxxxxxxxxx
> Subject: Re: a need for speed
> 
> 
> Lim,
> 
> You could use Query to create the summary.
> 
> Order by Area Code, Prefix, Suffix, Terminal.
> Break level 1 on Area Code, Prefix, Terminal.
> Min & Max on Suffix.
> Output to a summary file.
> 
> It won't let you output to your own file format.  It will create a break
> level indicator field in the output file which you won't want.  You also get
> a summary record with min and max on the Suffix over the entire file.  But
> it does give you the detail you want.
> 
> Paul
> 
> --
> 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.
> 
>