Query/400 will not work on DDM files.
SQL will work if you do a CONNECT TO first, and if you did WRKRDBDIRE and
set that up first.  But connecting to do joins has me concerned.  I assume
you mean filea is on one system and fileb is on another and you want to
join them together.
I don't use OPNQRYF.  With any luck it won't, instead encouraging you to
use SQL.

Rob Berendt
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin

                    "M. Lazarus"
                    <mlazarus@ttec.com>       To:     midrange-l@midrange.com
                    Sent by:                  cc:
                    midrange-l-admin@mi       Fax to:
                    drange.com                Subject:     Queries between 

                    01/04/2002 01:45 PM
                    Please respond to

  Are there any limitations of creating queries between /400
systems?  Implementing joins come to mind.  Is a DDM file the best way to
implement it?  Are there any capability differences in this regard between
Query/400, SQL and OPNQRYF?  TIA.


As an Amazon Associate we earn from qualifying purchases.

This thread ...


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

This mailing list archive is Copyright 1997-2022 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.