Re: Finding a suitable key

Juris,

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

>What would be the easiest (and maybe fastest, too) method to find out
>the lowest unused primary key in a file? Another question might be the
>fastest method to find any unused primary key in a file, but as I think
>the answers should be almost the same.



=======================================================================
Kerry Enman                  <kerry.enman@utas.edu.au>
Corporate Data Services      Phone
(03) 6226 2086
University of Tasmania       Fax    (03) 6226 7537
Churchill Ave,

Sandy Bay   7005             (GPO Box 252-69, HOBART  7001)
Tasmania,   Australia

=======================================================================


* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* 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          *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *