Page 1 of 1
JNF1 & JNF2 control cards
Posted:
Thu Sep 16, 2010 10:15 pm
by ranga_subham
Hi,
Which version of Syncsort supports JNF1 & JNF2 control cards on joinkeys operations?
Thanks.
Re: JNF1 & JNF2 control cards
Posted:
Thu Sep 16, 2010 11:11 pm
by Alissa Margulies
Support for the JOIN feature was included as of SyncSort for z/OS 1.2.0, which was released back in April 2005. The SORTJNF1 and SORTJNF2 DD statements, along with the JOINKEYS and REFORMAT control statements are all part of that support.
Regards,
Re: JNF1 & JNF2 control cards
Posted:
Thu Oct 28, 2010 3:07 pm
by ranga_subham
Alissa, which version of SYNCSORT supports "JNF1CNTL" and "JNF2CNTL"?
I get error when I try them along with JOINKEYS !!
Thanks.
Re: JNF1 & JNF2 control cards
Posted:
Fri Oct 29, 2010 12:20 am
by dick scherrer
Hello,
Do not post questions in another forum, receive DFSORT answers there, and then ask why they don't work for Syncsort here. . .
If this happens again, your ability to post here will be restricted. . .
d
Re: JNF1 & JNF2 control cards
Posted:
Fri Oct 29, 2010 1:46 am
by Alissa Margulies
Please post the error you are getting.
Re: JNF1 & JNF2 control cards
Posted:
Fri Oct 29, 2010 4:04 pm
by ranga_subham
dick scherrer wrote:Hello,
Do not post questions in another forum, receive DFSORT answers there, and then ask why they don't work for Syncsort here. . .
If this happens again, your ability to post here will be restricted. . .
d
Dick, I don't understand what you say.....I am sorry.
Thanks.
Re: JNF1 & JNF2 control cards
Posted:
Fri Oct 29, 2010 4:45 pm
by ranga_subham
Alissa,
I tried the first solution given in post
syncsort-synctool/topic2938.html because you said JNF1CNTL and JNF2CNTL works in SYNCSORT.
It is abending with U0016.
//STEP0001 EXEC PGM=SORT
//SORTJNF1 DD *
MAINFRAME12345
JOB3CONTROLLANG
DFSSORTOUTRECFL
//SORTJNF2 DD *
SOMEVALUESHERE
SOMEVALUESHERE
SOMEVALUESHERE
//SORTOUT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSIN DD M
JOINKEYS FILES=F1,FIELDS=(81,8,A),SORTED
JOINKEYS FILES=F2,FIELDS=(81,8,A),SORTED
REFORMAT FIELDS=(F2:1,2,F1:1,9,F2:12,3)
SORT FIELDS=COPY
//JNF1CNTL DD *
INREC OVERLAY=(81:SEQNUM,8,ZD)
//JNF2CNTL DD *
INREC OVERLAY=(81:SEQNUM,8,ZD)
//*
Am I wrong somewhere?
Sysout:
********************************* TOP OF DATA **********************************
SYNCSORT FOR Z/OS 1.3.2.2R XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXX z/OS 1.11.0
SYNCSORT LICENSED FOR CPU SERIAL NUMBER XXXXX, MODEL XXXXXXXX LICEN
SYSIN :
JOINKEYS FILES=F1,FIELDS=(81,8,A),SORTED
JOINKEYS FILES=F2,FIELDS=(81,8,A),SORTED
REFORMAT FIELDS=(F2:1,2,F1:1,9,F2:12,3)
SORT FIELDS=COPY
WER276B SYSDIAG= 33467, 646380, 646380, 1538625
WER164B 102,308K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,
WER164B 0 BYTES RESERVE REQUESTED, 1,008K BYTES USED
WER146B 12K BYTES OF EMERGENCY SPACE ALLOCATED
WER449I SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE
WER486A ERROR IN JNF1 PROCESSING
WER482I JNF1 STATISTICS
WER483B 6,908K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,
WER483B 0 BYTES RESERVE REQUESTED, 1,008K BYTES USED
WER108I SORTJNF1 : RECFM=FB ; LRECL= 80; BLKSIZE= 80
WER027A CONTROL FIELD BEYOND RECORD
******************************** BOTTOM OF DATA ********************************
I presume that the alternative solution you provided is the only way to achieve it and not with JNF1CNTL and JNF2CNTL as SYNCSORT is not equipped with these two control statements.
Thanks for your time.
Re: JNF1 & JNF2 control cards
Posted:
Fri Oct 29, 2010 11:24 pm
by dick scherrer
Hello,
dick scherrer wrote:Hello,
Do not post questions in another forum, receive DFSORT answers there, and then ask why they don't work for Syncsort here. . .
If this happens again, your ability to post here will be restricted. . .
d
Dick, I don't understand what you say.....I am sorry.
What i've said is that you should not post the same topic in multiple forum sites. This exact topic was asked by you and answered as a DFSORT question elsewhere. And you are trying to use the DFSORT solution provided there and posting the error here in the Syncsort part of this forum.
I presume that the alternative solution you provided is the only way to achieve it
The referenced Syncsort solution has been available for a very long time. . . There is no need for JNF1CNTL and JNF2CNTL. Suggest you focus on using the features of the product you are using and not some other product. . .