Re: Join Logical like WRKQRY's join type '3'

["Mark Walter" <mwalter@xxxxxxxxxx>]

Something like this:
OPNQRYF  FILE((ordsked) (cusmas)) +
                       FORMAT(skedwork) +
                       JFLD((1/cusnbr 2/cusnbr)) +
                        JDFTVAL(*ONLYDFT) +
                        MAPFLD(cusnbr '1/cusnbr')

The join default vaule of *ONLYDFT will cause an exception join.

-----Original Message-----
From: Bale, Dan <DBale@TFSA.Textron.com>
To: MIDRANGE-L@midrange.com <MIDRANGE-L@midrange.com>
Date: Monday, March 06, 2000 1:48 PM
Subject: Join Logical like WRKQRY's join type '3'


>I have a requirement to produce an inquiry listing where records from file
A
>do not have a matching record in file B.  In WRKQRY, I would use join type
>'3' (Unmatched records with primary file).  It would select, from the
>primary file, only records that have no match in the secondary file.
>
>Is it possible to create a join logical file with this type of unmatched
>logic?  I was unable to find anything describing this in the DDS or the DB2
>manuals.
>
>If not, can it be accomplished through OPNQRYF or SQL.  And if it can,
could
>someone please post an example?  Basically, I want to select records from
>file A in which the item number is not found in the Item Master (file B).
>
>TIA,
>Dan Bale
>+---
>| 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
>+---
>

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