Re: OPNQRYF question

[AlNovick@xxxxxxx]

Joe:

The key fields must be in the file named in the FORMAT keyword.  I reccommend
creating a new PF with the DDS of both files and using that in the FORMAT
entry.

Alan Novick
Pressman Toy Corp
New Brunswick, NJ

In a message dated 97-06-13 01:54:07 EDT, jteff19@IDT.NET (Joe Teff) writes:

> Subj: Re: OPNQRYF question
>  Date:        97-06-13 01:54:07 EDT
>  From:        jteff19@IDT.NET (Joe Teff)
>  Sender:      mcsnet!midrange.com!midrange-l-owner@Mcs.Net
>  Reply-to:    MIDRANGE-L@midrange.com
>  To:  MIDRANGE-L@midrange.com
>  
>  >> 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   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *