|
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 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
