Re: a need for speed

[rick baird <rick.baird@xxxxxxxxx>]

select area,
       prefix,
       terminal,
       min(suffix),
       max(suffix)
group by area,
         prefix,
         terminal 
order by area,
         prefix,
         terminal 

On 8/18/05, Lim Hock-Chai <Lim.Hock-Chai@xxxxxxxxxxxxxxx> wrote:
> Can below be done without having to read thru each record in detail 
> file(Telephone Master)?
> 
> I need to summarize a big telephone master file (22M+) into ranges.  I'm 
> attempting to use read, reap, setll to avoid the need to read each phone 
> number record to create this summary file.  However, no luck so far.
> 
> The detail file looks like below:
> AreaCode    Prefix    Suffix    Terminal
>  601         123       0001      JSN
>  601         123       0002      JSN
>  601         123       0003      JSN
>  601         123       0004      JSN
>  601         123       0009      BTD
>  601         123       0010      BTD
>  601         123       0044      BTD
>  601         123       0091      JSN
>  601         123       0092      JSN
>  .
>  .
>  .
> 
> 
> The summary file is by AreaCode, Prefix, Terminal, From Suffix, to Suffix.  
> Using above data, the result should be as follow:
> AreaCode    Prefix    Terminal    From Suffix    to Suffix
> 601          123        JSN         0001           0004
> 601          123        BTD         0009           0044
> 601          123        JSN         0091           0092
> 
> 
> --
> 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.
> 
>