Can we do Join Pair and Unpair on different key flds



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

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

Postby 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.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

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

 

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

Postby 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.
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.
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
skolusu
 
Posts: 586
Joined: Wed Apr 02, 2008 10:38 pm
Has thanked: 0 time
Been thanked: 39 times

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

Postby Mann_B » Mon Jul 23, 2012 5:35 pm

I Apologize ....We use SYNCSORT.Thanks you for the response and your time.
Mann_B
 
Posts: 79
Joined: Wed Mar 31, 2010 11:48 am
Has thanked: 0 time
Been thanked: 0 time

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

Postby 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.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Previous

Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post