IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Sort JCL Help Needed to compare and delete between two files
IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
PostPosted: Mon Feb 20, 2012 2:57 am
 Reply with quote
Can you show us what is in the JNF1CNTL and JNF2CNTL files form your JCL, please?
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy
PostPosted: Mon Feb 20, 2012 3:01 am
 Reply with quote
the topic is getting out of hand... ( 40 posts, it looks like one of the longer topic around )
most probably will be locked shortly and delete after a while ...
no reason to clutter the forum with such a useless back and forth of useless info icon_evil.gif
Back to top
View user's profile Send private message
raj4neo
Warnings : 1
New User


Joined: 12 May 2006
Posts: 51
Location: India
PostPosted: Mon Feb 20, 2012 3:04 am
 Reply with quote
JCL we are using is

Code:

//SORTJNF1 DD DSN=*******,DISP=SHR     
//SORTJNF2 DD DSN=********,DISP=SHR     
//MATCHES  DD DSN=BPV380.E11,DISP=(NEW,CATLG,DELETE),                 
//           DATACLAS=MB001,                                         
//           DCB=(RECFM=VB,LRECL=3313)                               
//NOMATCH1 DD DSN=BPV380.E12,DISP=(NEW,CATLG,DELETE),                 
//           DATACLAS=MB001,                                         
//           DCB=(RECFM=VB,LRECL=3313)                               
//SYSIN   DD *               
JOINKEYS FILES=F1,FIELDS=(5,1000,A)   
JOINKEYS FILES=F2,FIELDS=(5,1000,A)   
JOIN UNPAIRED,F1                       
REFORMAT FIELDS=(F1:1,4,F2:1,4,F1:5)   
OPTION COPY                           
OUTFIL FNAMES=NOMATCH1,               
INCLUDE=(5,2,CH,EQ,X'0000'),           
OUTREC=(1,4,9)                         
 OUTFIL FNAMES=MATCHES,               
  INCLUDE=(5,2,CH,NE,X'0000'),         
  OUTREC=(1,4,9)                                                               
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
PostPosted: Mon Feb 20, 2012 4:56 am
 Reply with quote
Are you sure you don't have records of less than 1008 bytes? I don't know what that would do (maybe just an A message from Syncsort), so it is a stab. A joinkeys uses more storage than a norrmal sort, because each of the joinkeys is a sub-task to the main task. You've been coy about your EXEC card, but do you have a REGION=0M around anywhere?

Triple-check everything. If still nothing, take it to your support. If they get nowhere. take it to Syncsort.
Back to top
View user's profile Send private message
raj4neo
Warnings : 1
New User


Joined: 12 May 2006
Posts: 51
Location: India
PostPosted: Mon Feb 20, 2012 5:08 am
 Reply with quote
Hi Bill ,


Thanks For Your Extensive support , As for as My requirement is to match keys of 5-1000 , i ran with Region parameter also....
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM Goto page Previous  1, 2

 

Similar Topics
Topic Forum Replies
No new posts Need to set RC4 through JCL SORT DFSORT/ICETOOL 5
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts DELETE SPUFI DB2 1
No new posts DSNTIAUL driven delete IBM Tools 0
No new posts Write line by line from two files DFSORT/ICETOOL 7
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us