Re: a need for speed

[rick baird <rick.baird@xxxxxxxxx>]

oooh,
after further review.....   won't work - sorry.

back to the drawing board

On 8/18/05, rick baird <rick.baird@xxxxxxxxx> wrote:
> 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.
> >
> >
>