Page 2 of 2

Re: Join Paired Problem

PostPosted: Thu Feb 23, 2012 7:01 pm
by BillyBoyo
Don't you think it is probably related to the SORT, and therefore is removing duplicates from the output file? The manual will confirm.

Re: Join Paired Problem

PostPosted: Thu Feb 23, 2012 8:16 pm
by Alissa Margulies
I'm not sure I understand the question. The duplicates are removed after the JOIN processing and REFORMATing has taken place. Hence, in this case, based on the REFORMAT statement, only F2 records are being written out. Therefore, the duplicates from F2 are removed from the output. Does this answer your question? If not, please try to explain your question again.

Thank you.

Re: Join Paired Problem

PostPosted: Fri Feb 24, 2012 12:04 pm
by pjagathis
Hi Alissa,

Please apologize me if i am wrong.

According to your below statement, the duplicates are removed after only the reformat fields are executed. If so we can give "SUM FIELDS=NONE".

It will do the same..!

I thought that using the "DUPKEYS FIELDS=NONE" statement will remove the duplicates in any of 2 files before matching.

I think you have little bit more now.

Thanks much..!

Re: Join Paired Problem

PostPosted: Fri Feb 24, 2012 1:31 pm
by BillyBoyo
If you are going to contradict someone like Alissa, who has deep intimate knowledge of the product, you should at least provide references to the manual to support your statements, or sample input/output where you feel that this has occurred.

Re: Join Paired Problem

PostPosted: Fri Feb 24, 2012 5:06 pm
by pjagathis
Hi BillyBoyo,

I am not saying Alissa is wrong!

I am asking my thought is correct or wrong to her?

If I am wrong anywhere in my statement, Please apologize me..!

Re: Join Paired Problem

PostPosted: Fri Feb 24, 2012 6:16 pm
by BillyBoyo
I don't have Syncsort documentation. You do, I assume.

I think you'll discover that SUM FIELDS=NONE and DUPKEYS FIELDS=NONE would be the same, operate in the same way. I suspect DUPKEYS has some additional options which are not available on the SUM.

Look in your manual for references to the order in which things are done. If you have a joinkeys operation which is followed by a SORT then control statements after the SORT will refer to the SORT not something earlier.

Re: Join Paired Problem

PostPosted: Fri Feb 24, 2012 9:48 pm
by Alissa Margulies
In this case, the DUPKEYS and SUM statements are equivalent. you can use either one.

Re: Join Paired Problem

PostPosted: Mon Feb 27, 2012 4:58 pm
by pjagathis
Thanks Alissa for your response..!