Re: Missing numbers ( was Re: )

[Michael_Schutte@xxxxxxxxxxxx]

I the orginal question was for finding the first missing number. So I took
it as if he didn't care about the other missing numbers.


Michael Schutte
Admin Professional
Bob Evans Farms, Inc.




midrange-l-bounces@xxxxxxxxxxxx wrote on 04/16/2008 05:01:21 PM:

> Michael_Schutte@xxxxxxxxxxxx wrote:
>
> > sorry I put the +1 on the wrong field.
>
> For all of the discussion so far, and without actually running any
> of the examples, I haven't determined whether [+1] is sufficient. In
> the example, both '7' and '8' are sequentially missing. Would [+1]
> find '7' but miss '8'?
>
> Maybe more interesting but also without doing any testing, I wonder
> if lookahead fields in RPG might be useful. They require
> program-described files, but might be relatively quick. A lookahead
> would not only tell if any are missing but how many were missing
> sequentially.
>
> Tom Liotta
>
> > midrange-l-bounces@xxxxxxxxxxxx wrote on 04/16/2008 08:18:25 AM:
> >
> > > Exec SQL
> > > Select  Min(Field) FROM FILE  a
> > >  WHERE not exists (select '1' from file b where a.key1 = b.key1 and
> > a.field
> > > = b.field+1)
> > >
> > > midrange-l-bounces@xxxxxxxxxxxx wrote on 04/16/2008 04:57:07 AM:
> > >
> > > > Is there a way to select the numbers missing from a list of numbers ?
> > > >
> > > > I mean, if I have a table with keys  1, 2, 3, 5, 6, 9,
> > > >
> > > > can I find the numbers missing between 1 and 10? ie, return 4, 7, 8,
> > 10.
> > > > I could create a table with 1 zone filled with the numbers 1 to 10
> > > > and then do an outer join. But I need this in a program. I need to
> > > > find the smallest missing number in a given range of numbers.
> > > >
> > > > Thanks.
>
>
> --
> Tom Liotta
> The PowerTech Group, Inc.
> 19426 68th Avenue South
> Kent, WA 98032
> Phone  253-872-7788 x313
>         253-479-1416
> Fax    253-872-7904
> http://www.powertech.com
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.