Re: OPNQRYF question

["Joe Teff" <jteff19@xxxxxxx>]

>> From:  Joe Teff
>> 
>> Yesterday, I was trying to use an OPNQRYF statement that joins 2
>> files and use a field out of the second file as the key. I wasn't able to
>> get this to work. I'm on V3R1 now. I think I was able to do this
>> though at a past site. It was a year or 2 ago and the operating
>> system could have been anything from V3R0M5 up to V3R6. Is my
>> memory faulty here or can this be done on some versions of OS/400?
>
> From: Brian Johnson <brian@helpsystems.com>
> 
> You need OPNQRYF...ALWCPYDTA(*YES). 

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