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

Bale, Dan wrote:
> 
> 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).


Can't help you on first two methods, but RPGXX can do it in about 5
lines of
code which includes file specs.... The dreaded MR indicator will work
like
a champ for your little problem...
+---
| 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
+---