Re: Finding a suitable key

[DAsmussen@xxxxxxx]

Juris,

In a message dated 97-08-29 09:23:48 EDT, you write:

> > Try sequential by key. Check if the record just read is one increment
above
>  > the previous, if not, you have your key. You could continue this process
to
>  > find all unused keys.
>  > 
>  > regards Kerry
>  
>  Thanks, Kerry, You are right, this actually works and gives me what I
>  want, _BUT_ it has some drawbacks - it is expensive (I have to iterate
>  throughout the whole file) and I have to keep the previous key to
>  compare it with the current one, don't I? Correct me if I am wrong.

Darn, Juris!  I just realized that the quintessential MIDRANGE-L question was
never asked on this -- "Just WHY do you want to do it?".  The application
seems extreme, given the abilities of DB2/400...

Regards!

Dean Asmussen
Enterprise Systems Consulting, Inc.
Fuquay-Varina, NC  USA
(Between Raleigh and Research Triangle Park)
E-Mail:  DAsmussen@AOL.COM

"There is no greater loan than a sympathetic ear." -- Frank Tyger
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the RPG/400 Discussion Mailing List!  To submit a new         *
* message, send your mail to "RPG400-L@midrange.com".  To unsubscribe   *
* from this list send email to MAJORDOMO@midrange.com and specify       *
* 'unsubscribe RPG400-L' in the body of your message.  Questions should *
* be directed to the list owner / operator: david@midrange.com          *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *