Re: Finding a suitable key

[Dave Mahadevan <mahadevan@xxxxxxxx>]

Juris Krikis Jr. wrote:

> 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.
>
> What I'm doing at the moment is just CHAINing through the file,
> incrementing the search factor (Factor1) all the time, waiting for the
>
> error indicator to turn on. I'm not feeling like this is how it should
>
> be done, so any ideas would be greatly appreciated...
>
>

1.  Define the file Full Procedural2.  *LOVAL    SETLL   FILE
3.  READ FILE
4.  the key before the one you just got is the first available low.
5.  What do you mean by primary key?  Unique?


--
Thank You.

Regards

Dave Mahadevan.. mailto:mahadevan@fuse.net


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