Re: Looking for gaps in a key sequence

[CRPence <CRPbottle@xxxxxxxxx>]

Loyd Goodbar wrote:
> If you were on V5R4, it sounds like something recursive SQL could
> perform. Given that you must compare one value in sequence to the
> next (or previous depending on the algorithm) I don't know a
> quick way other than reading the sequence in order. With the
> proper indexes, runtime should be blazing fast.
>
> On Wed, Jun 24, 2009 at 10:26 AM, James H. H. Lampert wrote:
>
> > Given a key sequence in a file, really just a series of
> > numbers, does anybody know of an algorithm, other than brute
> > force, for finding gaps in the sequence?

  A past thread on this list exists, and a recursive query was 
documented.  Per my comment "something like ... should work", 
presumably the query was untested.

http://archive.midrange.com/midrange-l/200808/threads.html#00254
http://archive.midrange.com/midrange-l/200808/msg00251.html

  In that thread I gave a search for finding some other articles 
[referred to by others in that thread] from this list, using search 
tokens: find holes sequence sql

Regards, Chuck