Re: [MI400] Retrieving key field info from OPNQRYF command

[Allen Hartley <hartley@xxxxxxxxxxxxxxxxxxx>]

Dennis,

I use the QDBRTVFD API to get the file information FILD0100 and from that I
get the key information based on the key offset, but this is only for the
file which has no keys and not for the currently used access path
(OPNQRYF).  I tried to use FILD0300 to retrieve the key field information
but it comes back with an error stating that the file is not a keyed file.

Allen

Dennis Lovelady wrote:

> Hi, Allen:
>
> Have a look at the QDBRTVFD API.
>
> HTH
> Dennis
>
> Allen Hartley <hartley@prodatacomputer.com>@midrange.com on 01/22/2002
> 11:04:36 AM
>
> Please respond to mi400@midrange.com
>
> Sent by:  mi400-admin@midrange.com
>
> To:   "mi400@midrange.com" <mi400@midrange.com>
> cc:
> Subject:  [MI400] Retrieving key field info from OPNQRYF command
>
> I need to retrieve the key field names from an OPNQRYF access path.
> If I use the OPNQRYF command to open an access path over a non keyed
> physical file and specify a key field, OPNQRYF FILE((GLMASTER))
> KEYFLD((ACCT#)), the file information data structure tells me that it is
> a keyed file with one key but not which field is the key field.  Is
> there a way to determine which field is being used as the key field in
> the OPNQRYF access path.
>
> _______________________________________________
> This is the MI Programming on the AS400 / iSeries (MI400) mailing list
> To post a message email: MI400@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/mi400
> or email: MI400-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/mi400.