JNF1 & JNF2 control cards



Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL

JNF1 & JNF2 control cards

Postby ranga_subham » Thu Sep 16, 2010 10:15 pm

Hi,

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

Thanks.
ranga_subham
 
Posts: 279
Joined: Fri Jul 18, 2008 7:46 pm
Has thanked: 0 time
Been thanked: 1 time

Re: JNF1 & JNF2 control cards

Postby 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,
Alissa Margulies
Syncsort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com
Alissa Margulies
Global moderator
 
Posts: 369
Joined: Tue Feb 26, 2008 11:15 pm
Location: USA
Has thanked: 1 time
Been thanked: 3 times

Re: JNF1 & JNF2 control cards

Postby 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.
ranga_subham
 
Posts: 279
Joined: Fri Jul 18, 2008 7:46 pm
Has thanked: 0 time
Been thanked: 1 time

Re: JNF1 & JNF2 control cards

Postby 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
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: JNF1 & JNF2 control cards

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

Please post the error you are getting.
Alissa Margulies
Syncsort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com
Alissa Margulies
Global moderator
 
Posts: 369
Joined: Tue Feb 26, 2008 11:15 pm
Location: USA
Has thanked: 1 time
Been thanked: 3 times

Re: JNF1 & JNF2 control cards

Postby 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.
ranga_subham
 
Posts: 279
Joined: Fri Jul 18, 2008 7:46 pm
Has thanked: 0 time
Been thanked: 1 time

Re: JNF1 & JNF2 control cards

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


//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.
ranga_subham
 
Posts: 279
Joined: Fri Jul 18, 2008 7:46 pm
Has thanked: 0 time
Been thanked: 1 time

Re: JNF1 & JNF2 control cards

Postby 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. . .
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post