RE: OPNQRYF question

[Brian Johnson <brian@xxxxxxxxxxxxxxx>]

Looks like you need to create a new file whose record format includes all   
the fields you want from INVDET, and OHNAM from ORDHDR.  Then use that   
new file in the FORMAT parameter.  OPNQRYF will use the new file's format   
to determine which fields are in the query result (now you getting only   
INVDET fields), and you should be able to name any of the fields as key   
fields.



 ----------
From:  Joe Teff
Sent:  Thu, Jun 12, 1997 21:35 PM

     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.


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