MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » September 1998

Re: OPNQRYF (JOIN), CPYFRMQRYF


  • Subject: Re: OPNQRYF (JOIN), CPYFRMQRYF
  • From: Richard Baird <rbbaird@xxxxxxxxxxx>
  • Date: Thu, 10 Sep 1998 10:57:18 -0500
  • Organization: Premium Systems, Inc.

fixed

You must reference an existing physical file in the FORMAT parameter.

Create a DDS source file containing the fields from both files you
wish to join, and create it empty.  The opnqryf command only uses this
file to tell it what the output is supposed to look like.

Hope this helps,

Rick

KOKOREV@conversbank.ru wrote:
> 
> OPNQRYF    FILE((PF018A10) (PFPCBAN)) FORMAT(NEW$) +
>              JFLD((PF018A10/POST PFPCBAN/AIA05)) +
>              MAPFLD((POST 'pf018a10/post') (HA003 +
>              'pfpcban/ha003')) OPNID(NEWF)
> 
> And I receive:
> 
> File NEW$ in library *LIBL not found.
> CPF9812 received by procedure CLTEST.
> 
> Really, file NEW$ not exist, but I suppose that command OPNQRYF know what
> kind format need make.
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact