IBM Mainframe Forum

by **dick scherrer** » Fri Jul 20, 2012 7:26 pm

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.

by **skolusu** » Fri Jul 20, 2012 10:15 pm

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.

Select all

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.

by **Mann_B** » Mon Jul 23, 2012 5:35 pm

I Apologize ....We use SYNCSORT.Thanks you for the response and your time.

by **BillyBoyo** » Mon Jul 23, 2012 6:08 pm

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.

IBM Mainframe Forum

Can we do Join Pair and Unpair on different key flds

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

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

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

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