Re: Opening files with multiple keys as program-described

[Joep Beckeringh <joep@xxxxxxxxxxxxxxxxxxx>]

James,

In the F-spec you just specify the key length (20) and type (A). Type A (char) 
might seem strange in your case, but for a compound key you'll need a data 
structure for random access. You can specify the starting location of the key 
with the KEYLOC keyword, but I don't think this has any use.

If you need to chain to the file you have to define a data structure; in your 
case it will have to be 20 long and should contain an 11 byte zoned field an a 9 
byte zoned field.

Joep Beckeringh


James H H Lampert wrote:

> Something I don't quite get, in the ILE RPG docs:
>
> I have a file with two non-adjacent keys.
> Is it possible to open this file from ILE RPG as program-described (to
> avoid level-check issues without overrides, and without disabling level
> checking for other programs using the file), and chain it on both keys?
>
> How do I code this?
>
> For argument's sake, I'll call the first key "foo"; it's 11 bytes of zoned
> decimal, starting at byte position 49 in the record. I'll call the second
> key "bar"; it's 9 bytes of zoned decimal, starting at byte position 39 in
> the record. I'll call the intervening byte (byte position 48) "baz."
>
> And please note that, now that I have a strictly RPG query (as opposed to
> a query that was only incidentally involving an RPG program), I have put
> it on the RPG list, rather than the MIDRANGE list.
>
> --
> JHHL