IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

find non-matching reocrds


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Akatsukami

Global Moderator


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

PostPosted: Thu Dec 01, 2011 8:20 pm
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

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Thu Dec 01, 2011 8:24 pm
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

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Thu Dec 01, 2011 8:44 pm
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 ...
ibmmainframes.com/viewtopic.php?t=41086&highlight=alissa+manuals
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


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

PostPosted: Thu Dec 01, 2011 8:52 pm
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

Superior Member


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

PostPosted: Thu Dec 01, 2011 9:17 pm
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

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Thu Dec 01, 2011 9:20 pm
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
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

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Thu Dec 01, 2011 10:51 pm
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

Moderator Emeritus


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

PostPosted: Thu Dec 01, 2011 11:35 pm
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

Superior Member


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

PostPosted: Fri Dec 02, 2011 2:22 pm
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
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

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Fri Dec 02, 2011 8:53 pm
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

Moderator Emeritus


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

PostPosted: Fri Dec 02, 2011 11:10 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM Goto page Previous  1, 2

 


Similar Topics
Topic Forum Replies
No new posts To find whether record count are true... DFSORT/ICETOOL 6
No new posts Find the size of a PS file before rea... COBOL Programming 13
No new posts Rexx pattern matching on PS qualifer ... CLIST & REXX 1
No new posts Find the occurrence of Key Field (Par... DFSORT/ICETOOL 6
No new posts Find a record count/numeric is multip... COBOL Programming 1
Search our Forums:

Back to Top