Re: OPNQRYF (JOIN), CPYFRMQRYF

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