what does the keyword JOIN UNPAIRED does?



Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL

what does the keyword JOIN UNPAIRED does?

Postby karthikchn » Thu Apr 29, 2010 6:20 pm

Can u tell me what does the keyword JOIN UNPAIRED does?
karthikchn
 
Posts: 5
Joined: Thu Apr 29, 2010 6:02 pm
Has thanked: 0 time
Been thanked: 0 time

Re: what does the keyword JOIN UNPAIRED does?

Postby William Thompson » Thu Apr 29, 2010 7:25 pm

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.
William Thompson
 
Posts: 81
Joined: Sat Jun 09, 2007 4:24 am
Location: Tucson AZ
Has thanked: 0 time
Been thanked: 1 time


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post