Re: CHAIN versus SETLL

[peteh@xxxxxxxxxxxxxxxx (Pete Hall)]

>> Not necessarily, Kimosabee!  The AS/400 allows you to chain with a
-partial- key and match on the part you provide!  (I forget if this only
works with a composite key (ie more than 1 field) and if you have to use
complete fields as the partial key) <<

Paul,

With an externally described file, you can use a field, but it must
exactly match the definition of the first key field. With a KLIST, you
can use the first n fields of an m part key where m>=n. Here again, each
KLIST field must exactly match the corresponding key field. However, if
you want to use a program described file, you can use a character
variable of any length you like up to the total length of the key. It
does not necessarily need to have a length that matches the end of a key
subfield.

Pete


--
 - Pete Hall peteh@earth.inwave.com
http://www.inwave.com/~peteh/

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List!  To submit a new message,   *
* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
* this list send email to MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *