Re: OPNQRYF question

[Dave Mahadevan <mahadevan@xxxxxxxx>]

Joe Teff wrote:

> 
> My open query stmt
> 
>      OPNQRYF  FILE((INVDET) (ORDHDR)) +
>                          FORMAT(INVDET INVDETRC) +
>                          QRYSLT('OJACTV *NE "D" *AND OJPMTC *GE 1 +
>                              *AND OJQTOR *GE 0 *AND OHSUFX *EQ 0 +
>                              *AND OJCRTN *NE "RSF") +
>                          KEYFLD((ORDHDR/OHNAM)) +
>                         JFLD((OJORDN OHORDN)) +
>                          ALWCPYDTA(*YES)
> 
> When I run the CL, I get this messages
> 
>      Key field ORDHDR/OHNAM not valid for record format.
> 
> Fields named OJ.... are from file INVDET and fields named
> OH.... from ORDHDR. Is this a problem with V3R1 or can I not use
> a field from a secondary file as a key in any version of OS/400?

Instead of the FORMAT you have, you need FORMAT(ORDHDR)

-- 
Thank You.

Regards

Dave Mahadevan.. mailto:mahadevan@fuse.net


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