Re: Finding a suitable key

["Juris Krikis Jr." <juris.rfb@xxxxxxxxxxx>]

Hi, Dean!

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

Well, I'm not sure if my english is good enaugh to understand the
question _OR_ the point :-), but if the question is "why do I want to
search for holes in my keys?" then perhaps my answer is:

For example there are many customers placing many orders and the orders
expire and fulfill all the time so there are really _LOTS_ of orders in
the whole, but not really lots of at the moment. I am keeping a database
of these orders. If I just assign a key to an order generously (just
Max(keys)+1) I _MIGHT_ someday run out of keys (I don't want to use
packed 31-digit numbers so 10-digit binary integers might not do it). So
I would like to use the used keys again once they are deleted (some
orders might last forever). Maybe I'm getting my problem quite wrong,
but that's just how I see it... Please, tell me if and where I'm
wrong...

                                        Regards, Juris.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* 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          *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *