Page 1 of 1

what does the keyword JOIN UNPAIRED does?

PostPosted: Thu Apr 29, 2010 6:20 pm
by karthikchn
Can u tell me what does the keyword JOIN UNPAIRED does?

Re: what does the keyword JOIN UNPAIRED does?

PostPosted: Thu Apr 29, 2010 7:25 pm
by William Thompson
About Retaining Unpaired Records, SyncSort for z/OS 1.3 Programmer’s Guide wrote:When joining files, a record from one file may or may not have a match in the other file. A match occurs when the contents of the join keys in the record from the first file equal the contents of the join keys in the record from the second file.
By specifying the JOIN statement you can discard unpaired records from one or both files, or retain unpaired records from both files.