Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
find non-matching reocrds
Goto page Previous  1, 2
 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
xknight

Active User


Joined: 22 Jan 2008
Posts: 117
Location: Liberty city

PostPosted: Thu Dec 01, 2011 10:19 am    Post subject:
Reply with quote

Hello Nilesh,

Quote:
Gerry,

I tried above JCL but failed with below error


Did you tried the posted JOINS snippet.

Would you let us know, what did you get icon_question.gif
Back to top
View user's profile Send private message

nileshyp

New User


Joined: 22 Jun 2005
Posts: 65
Location: Mumbai

PostPosted: Thu Dec 01, 2011 10:48 am    Post subject: Reply to: find non-matching reocrds
Reply with quote

I tried with the JCL which you provided but still I got below error

Code:

SYNCSORT FOR Z/OS  1.1DR   TPF3     

SYSIN :                                                                       
  JOINKEYS FILE=F1,FIELDS=(1,300,A)                                           
  *                                                                           
  JOINKEYS FILE=F2,FIELDS=(1,300,A)                                           
  *                                                                           
  SORT FIELDS=COPY                                                           
  JOIN UNPAIRED,F1,ONLY                                                       
  *                                                                           
  REFORMAT FIELDS=(F1:1,300)                                                 
  *                                                                           
WER275A  NO KEYWORDS FOUND ON CONTROL STATEMENT                               
WER275A  NO KEYWORDS FOUND ON CONTROL STATEMENT                               
WER275A  NO KEYWORDS FOUND ON CONTROL STATEMENT                               
WER275A  NO KEYWORDS FOUND ON CONTROL STATEMENT
Back to top
View user's profile Send private message
enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10626
Location: italy

PostPosted: Thu Dec 01, 2011 11:21 am    Post subject: Reply to: find non-matching reocrds
Reply with quote

supposing that the snippets provided were tested...
Your Syncsort level does not support JOINKEYS
Back to top
View user's profile Send private message
xknight

Active User


Joined: 22 Jan 2008
Posts: 117
Location: Liberty city

PostPosted: Thu Dec 01, 2011 7:11 pm    Post subject:
Reply with quote

Hello,

I am not sure about the Syncsort level 1.1, I guessed, JOINKEYS FILE='nn' would support.

Between you haven't replied to bill's query. Do you have manual for the version installed at your site.
Back to top
View user's profile Send private message
nileshyp

New User


Joined: 22 Jun 2005
Posts: 65
Location: Mumbai

PostPosted: Thu Dec 01, 2011 8:16 pm    Post subject: Reply to: find non-matching reocrds
Reply with quote

No.. I don't have manual. Please someone have please share it with us.

Regards,
Neil
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1789
Location: Bloomington, IL

PostPosted: Thu Dec 01, 2011 8:20 pm    Post subject: Re: Reply to: find non-matching reocrds
Reply with quote

nileshyp wrote:
No.. I don't have manual. Please someone have please share it with us.

You realize, of course, that you are asking us to steal for the benefit of those misers for which you have the misfortune to work.
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7312

PostPosted: Thu Dec 01, 2011 8:24 pm    Post subject: Reply to: find non-matching reocrds
Reply with quote

Well, enough, I think. You are a Consultant. I suggest you write a program to do it, or order someone at your site to do it. I don't think anyone is going to toss any more solutions at you, just on the off-chance that they'll work at your site.
Back to top
View user's profile Send private message
enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10626
Location: italy

PostPosted: Thu Dec 01, 2011 8:44 pm    Post subject: Reply to: find non-matching reocrds
Reply with quote

Quote:
No.. I don't have manual. Please someone have please share it with us.

a forum is not a tool meant to fix poor organization issues


the syncsort manuals are available to organizations licensed for their product
they are not available on the net
syncsort manuals are copyrighted material and as such they cannot be posted ( made publicly available ) anywhere nor privately provided by anybody


if You had cared to do a bit of forum surfing You would have found that
in many topics where the TS complained about the lack of syncsort manuals
Alissa Margulis was available to take actions in order to provide them!
search the forums and You will find the Alissa' s contact email address
like for example in ...
http://ibmmainframes.com/viewtopic.php?t=41086&highlight=alissa+manuals
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6254
Location: Mumbai, India

PostPosted: Thu Dec 01, 2011 8:52 pm    Post subject:
Reply with quote

On a little soft side I'd say -- Since there is only limited information here, if the problem is reproducible, then please add the following JCL to the step in question and rerun the job:
Code:
//$ORTPARM DD *
MSG=AP,LIST,BMSG,DEBUG
//SPYSET DD SYSOUT=*

This should produce additional diagnostic information that will help us to better address the issue.

In the mean while, please contact SyncSort Mainframe Product Services with the output produced as an email attachment.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6254
Location: Mumbai, India

PostPosted: Thu Dec 01, 2011 9:17 pm    Post subject:
Reply with quote

Also, I just did a random search and came to know joinkeys feature was incorporated in syncsort version 1.2. So you are actually behind.

Having said that, the sort-job you show does not match with the usual syntax strycture of JOINKEYS in SyncSort:
Quote:
//S1 EXEC PGM=SYNCSORT
//SYSOUT DD SYSOUT=*
//MASTER DD DSN=R2K0C00U.N0.MRP6909.MT.G0192V00,DISP=SHR
//KEY DD DSN=CRUMTEST.MRP6909.MT.NOV11,DISP=SHR
//SORTOUT DD DSN=CRUMTEST.MRP6909.MT.NOV11.DIFFER,
// DISP=(NEW,CATLG,DELETE),UNIT=SYSDA,SPACE=(CYL,(9,99),RLSE),
// DCB=(RECFM=FB,LRECL=300,BLKSIZE=0)
//SYSIN DD *
JOINKEYS F1=MASTER,FIELDS=(1,300,A)
JOINKEYS F2=KEY,FIELDS=(1,300,A)
REFORMAT FIELDS=(F1:1,300)
SORT FIELDS=COPY
OUTFIL FNAMES=OUT,OUTREC=(1:300)
/*
//

It should have been:
Quote:
//S1 EXEC PGM=SYNCSORT
//SYSOUT DD SYSOUT=*
//SORTJNF1 DD DSN=R2K0C00U.N0.MRP6909.MT.G0192V00,DISP=SHR
//SORTJNF2 DD DSN=CRUMTEST.MRP6909.MT.NOV11,DISP=SHR
//SORTOUT DD DSN=CRUMTEST.MRP6909.MT.NOV11.DIFFER,
// DISP=(NEW,CATLG,DELETE),UNIT=SYSDA,SPACE=(CYL,(9,99),RLSE),
// DCB=(RECFM=FB,LRECL=300,BLKSIZE=0)
//SYSIN DD *
JOINKEYS FILE=F1,FIELDS=(1,300,A)
JOINKEYS FILE=F2,FIELDS=(1,300,A)
REFORMAT FIELDS=(F1:1,300)
SORT FIELDS=COPY
OUTFIL FNAMES=OUT,OUTREC=(1:300)
/*
but this does not guarantee any solution, sorry.
Back to top
View user's profile Send private message
enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10626
Location: italy

PostPosted: Thu Dec 01, 2011 9:20 pm    Post subject: Reply to: find non-matching reocrds
Reply with quote

Anuj!
the TS did not get that far ... SYNCSORT complained on the JOINKEY stuff

Code:
SYSIN :                                                                       
  JOINKEYS FILE=F1,FIELDS=(1,300,A)                                           
  *                                                                           
... ... ...                           
WER275A  NO KEYWORDS FOUND ON CONTROL STATEMENT                               


unfortunately we are just wasting time here...
Back to top
View user's profile Send private message
nileshyp

New User


Joined: 22 Jun 2005
Posts: 65
Location: Mumbai

PostPosted: Thu Dec 01, 2011 10:31 pm    Post subject: Reply to: find non-matching reocrds
Reply with quote

Thanks Anuj for your solution but it gives same error msg.

I am trying to resolve the issue by writing EZtrieve code.

Thanks everyone for your sincere support and feedback.

Regards,
Neil
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7312

PostPosted: Thu Dec 01, 2011 10:51 pm    Post subject: Reply to: find non-matching reocrds
Reply with quote

You do mean Easytrieve Plus? Not Easytrieve 9.0D which has been out of maintenance for years?

:-)

With the built-in file matching, should be no problem. You'd have done it by now if you'd not stuck to trying this sort solution with functions not in your product....
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19254
Location: Inside the Matrix

PostPosted: Thu Dec 01, 2011 11:35 pm    Post subject:
Reply with quote

Hello,

Why the continuing attempts with this out of data release?
Quote:
SYNCSORT FOR Z/OS 1.1DR TPF3
Release 1.1 has never supported JOINKEYS and i suspect never will. If the organization is so unwilling to keep critical system software reasonable current, they deserve all of the problems and lost time they get. . . icon_sad.gif

What is wanted for this is a 2-file match/merge (or line-balance as is sometimes known).

It can be very easily done in Easytrieve or COBOL (as long as there is some kind of experienced (anyone more experienced than a student) coder available to work on it).
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6254
Location: Mumbai, India

PostPosted: Fri Dec 02, 2011 2:22 pm    Post subject:
Reply with quote

Enrico - I should have said that even if the TS gets a version upgrade the syntax in question is not correct... icon_redface.gif
Back to top
View user's profile Send private message
bodatrinadh

Active User


Joined: 05 Jan 2007
Posts: 101
Location: chennai (India)

PostPosted: Fri Dec 02, 2011 8:31 pm    Post subject: Reply to: find non-matching reocrds
Reply with quote

I think the sort fields should start from position 3 not from position 1. Pls try this and let us know.

Code:
//S1 EXEC PGM=SYNCSORT
//SYSOUT DD SYSOUT=*
//SORTJNF1 DD DSN=R2K0C00U.N0.MRP6909.MT.G0192V00,DISP=SHR
//SORTJNF2 DD DSN=CRUMTEST.MRP6909.MT.NOV11,DISP=SHR
//SORTOUT DD DSN=CRUMTEST.MRP6909.MT.NOV11.DIFFER,
// DISP=(NEW,CATLG,DELETE),UNIT=SYSDA,SPACE=(CYL,(9,99),RLSE),
// DCB=(RECFM=FB,LRECL=300,BLKSIZE=0)
//SYSIN DD *
  JOINKEYS FILE=F1,FIELDS=(1,300,A)
  JOINKEYS FILE=F2,FIELDS=(1,300,A)
  REFORMAT FIELDS=(F1:1,300)
  SORT FIELDS=COPY
  OUTFIL FNAMES=OUT,OUTREC=(1:300)
/*

Thanks
-3nadh
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7312

PostPosted: Fri Dec 02, 2011 8:53 pm    Post subject: Reply to: find non-matching reocrds
Reply with quote

As with your example, without the Code tags, they look to start in Column 1, but don't.

The version of Syncsort in question, which is very old (up to nine years) just does not support the functions....
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19254
Location: Inside the Matrix

PostPosted: Fri Dec 02, 2011 11:10 pm    Post subject:
Reply with quote

Hello,

Quote:
I think the sort fields should start from position 3 not from position 1.
What we think has little to do with trying to use functions NOT supported in a product/release. Until TS oganization upgrades the sort product, JOINxxxx is NOT going to happen.

And the code is in the proper positions. As Bill mentioned, using the Code tag is most helpful for all of us who would like to help.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Goto page Previous  1, 2
Page 2 of 2

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts One-One matching using SORT dearlux SYNCSORT 6 Fri Oct 11, 2019 12:11 am
No new posts Adding FIND to ISPF Panel display of ... Harold Barnes TSO/ISPF 3 Mon Oct 07, 2019 5:46 pm
No new posts Find out which PSB is currently sched... Andi1982 IMS DB/DC 0 Mon Sep 24, 2018 3:16 pm
No new posts How to find if segment is read in any... Priyanka AR IMS DB/DC 12 Thu Sep 20, 2018 1:34 pm
No new posts Sort card to find duplicates, without... anand1204 DFSORT/ICETOOL 15 Fri Aug 31, 2018 12:13 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us