• Subject: Re: OPNQRYF question
  • From: Dave Mahadevan <mahadevan@xxxxxxxx>
  • Date: Fri, 13 Jun 1997 11:31:06 -0400
  • Organization: Stoner and Associates

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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.