Re: Queries between systems

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 
systems


                    01/04/2002 01:45 PM
                    Please respond to
                    midrange-l






  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.

  -mark