IBM Mainframe Forum

by **ranga_subham** » Thu Sep 16, 2010 10:15 pm

Hi,

Which version of Syncsort supports JNF1 & JNF2 control cards on joinkeys operations?

Thanks.

by **Alissa Margulies** » Thu Sep 16, 2010 11:11 pm

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,

by **ranga_subham** » Thu Oct 28, 2010 3:07 pm

Alissa, which version of SYNCSORT supports "JNF1CNTL" and "JNF2CNTL"?

I get error when I try them along with JOINKEYS !!

Thanks.

by **dick scherrer** » Fri Oct 29, 2010 12:20 am

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

by **Alissa Margulies** » Fri Oct 29, 2010 1:46 am

Please post the error you are getting.

by **ranga_subham** » Fri Oct 29, 2010 4:04 pm

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.

by **ranga_subham** » Fri Oct 29, 2010 4:45 pm

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.

Select all

//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:

Select all

********************************* 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.

by **dick scherrer** » Fri Oct 29, 2010 11:24 pm

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. . .

IBM Mainframe Forum

JNF1 & JNF2 control cards

JNF1 & JNF2 control cards

Re: JNF1 & JNF2 control cards

Re: JNF1 & JNF2 control cards

Re: JNF1 & JNF2 control cards

Re: JNF1 & JNF2 control cards

Re: JNF1 & JNF2 control cards

Re: JNF1 & JNF2 control cards

Re: JNF1 & JNF2 control cards