Re: finding a suitable key

chronus@mole.slip.net wrote:
> I guess my main concern here is that you're creating a loop here
> when you can just do a *LOVAL SETLL and READ the last record.  Your
> file is already keyed.  Why are you chaining to every record in your
> file?   (Very costly performance wise, particularly if you have a
> large number of records in this file later on.)   If I understand the
> intent of your programme (and I guess I'm not understanding
> completely why you would want to do this...), you only need the last
> record in the keyed physical.

        Well, actually, Ian, all I want is a key which had one feature - no
record with a key like that would be in the file Fil already.
        I'm starting to think that I really don't understand a lot here 'cause
that's the only explanation I can think of why nobody here understands
what I'm after :-).
        I wouldn't want to chain to every record, but that's the only thing I
can think of to make sure that this key is unique and therefore suitable
to be in the file for which it has to be a primary keys.
        Once again, everyone - sorry for not being able to express myself clear
enaugh. Thanks a lot for Your help, I really appreciate it.

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