View previous topic :: View next topic
|
Author |
Message |
xknight
Active User
Joined: 22 Jan 2008 Posts: 117 Location: Liberty city
|
|
|
|
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 |
|
Back to top |
|
|
nileshyp
New User
Joined: 22 Jun 2005 Posts: 65 Location: Mumbai
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
supposing that the snippets provided were tested...
Your Syncsort level does not support JOINKEYS |
|
Back to top |
|
|
xknight
Active User
Joined: 22 Jan 2008 Posts: 117 Location: Liberty city
|
|
|
|
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 |
|
|
nileshyp
New User
Joined: 22 Jun 2005 Posts: 65 Location: Mumbai
|
|
|
|
No.. I don't have manual. Please someone have please share it with us.
Regards,
Neil |
|
Back to top |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1788 Location: Bloomington, IL
|
|
|
|
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 |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
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 |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
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 |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
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 |
|
|
nileshyp
New User
Joined: 22 Jun 2005 Posts: 65 Location: Mumbai
|
|
|
|
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 |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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. . .
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 |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
Enrico - I should have said that even if the TS gets a version upgrade the syntax in question is not correct... |
|
Back to top |
|
|
bodatrinadh
Active User
Joined: 05 Jan 2007 Posts: 101 Location: chennai (India)
|
|
|
|
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 |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
|