Page 2 of 2

Re: Can we do Join Pair and Unpair on different key flds

PostPosted: Fri Jul 20, 2012 7:26 pm
by dick scherrer
Hello,

But I am getting errors
So, why are these errors not posted. . .

You need to post the diagnostic information (including the message ids) as well as all of the jcl and sort control statements.

Re: Can we do Join Pair and Unpair on different key flds

PostPosted: Fri Jul 20, 2012 10:15 pm
by skolusu
Mann_B wrote:Hi skolusu

My jobs is saying "SORTOUT INCLUDE/OMIT FIELD BEYOND RECORD ".

Thank you.


If your intention is get only mismatched records then remove the include cond checking if the indicator is '2' . ie.
OUTFIL BUILD=(1,80),                             
INCLUDE=(81,1,CH,EQ,C'B',AND,(9,4,CH,NE,82,4,CH))


Since you did not Show me the error messages I am guessing that you are running syncsort which does NOT support the ? on JOINKEYS. If you are indeed using syncsort, then you need to post questions in the syncsort forum. I'm a DFSORT developer. DFSORT and Syncsort are competitive products. I'm happy to answer questions on DFSORT and DFSORT's ICETOOL, but I don't answer questions on Syncsort.

Re: Can we do Join Pair and Unpair on different key flds

PostPosted: Mon Jul 23, 2012 5:35 pm
by Mann_B
I Apologize ....We use SYNCSORT.Thanks you for the response and your time.

Re: Can we do Join Pair and Unpair on different key flds

PostPosted: Mon Jul 23, 2012 6:08 pm
by BillyBoyo
Your topic has been moved to Syncsort.

If you still have problems, please show the JCL, the sort control cards, the sysout from the step and samples of your inputs and expected output for those inputs.