Re: Looking for gaps in a key sequence

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