Page 1 of 1

JNF1 & JNF2 control cards

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

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

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

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

PostPosted: Fri Oct 29, 2010 1:46 am
by Alissa Margulies
Please post the error you are getting.

Re: JNF1 & JNF2 control cards

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

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

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