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

Credit where due
IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1742
Location: Tirupur, India
PostPosted: Thu May 19, 2011 5:30 pm
 Reply with quote
Hello,

You could use the below job, provided that there are no data on fields from positions 73-80 on both the files.

Code:
//STEP1   EXEC PGM=ICETOOL                                         
//SORTIN1 DD DSN=WELLS.SORTIN.FILE1,DISP=SHR                           
//SORTIN2 DD DSN=WELLS.SORTIN2.FILE2,DISP=SHR                         
//TOOLMSG DD SYSOUT=*                                             
//DFSMSG  DD SYSOUT=*                                             
//TEMP1   DD DSN=&&TEMP1,UNIT=SYSDA,SPACE=(TRK,(10,15)),           
//        DISP=(MOD,PASS)                                         
//SORTOUT DD DSN=WELLS.SORTOUT,DISP=OLD                         
//TOOLIN DD *                                                     
 COPY FROM(SORTIN2) TO(TEMP1) USING(CTL1)                         
 COPY FROM(SORTIN1) TO(TEMP1) USING(CTL2)                         
 SPLICE FROM(TEMP1) TO(SORTOUT) ON(73,8,PD) WITH(11,10) USING(CTL3)
/*                                                                 
//CTL1CNTL DD *                                                   
 OUTREC BUILD=(1:1,10,73:SEQNUM,8,PD)                             
/*                                                                 
//CTL2CNTL DD *                                                   
 OUTREC BUILD=(11:11,10,73:SEQNUM,8,PD)                           
/*                                                                 
//CTL3CNTL DD *                                                   
 OUTFIL BUILD=(1,20,60X)                                           
/*


Code Based on Frank's "SMART DFSORT TRICKS" PDF.

Hope it helps.
Back to top
View user's profile Send private message
sqlcode1

Active Member


Joined: 08 Apr 2010
Posts: 577
Location: USA
PostPosted: Thu May 19, 2011 8:23 pm
 Reply with quote
Aslam,
If you have latest PTF for DFSort installed, this can be done using JOINKEYS...
Code:
//STEP001  EXEC PGM=SORT                           
//SYSOUT   DD SYSOUT=*                             
//SORTJNF1 DD *                                     
AAAAABBBBBCCCCCDDDDD                               
EEEEEFFFFFGGGGGHHHHH                               
/*                                                 
//SORTJNF2 DD *                                     
11111222223333344444                               
55555666667777788888                               
/*                                                 
//SORTOUT  DD your output file                             
//SYSIN DD *                                       
  JOINKEYS FILE=F1,FIELDS=(21,08,A),SORTED,NOSEQCK 
  JOINKEYS FILE=F2,FIELDS=(21,08,A),SORTED,NOSEQCK 
  REFORMAT FIELDS=(F2:01,10,F1:11,10)               
  SORT FIELDS=COPY                                 
/*                                                 
//JNF1CNTL DD *                                     
 INREC OVERLAY=(21:SEQNUM,8,ZD)                     
/*                                                 
//JNF2CNTL DD *                                     
 INREC OVERLAY=(21:SEQNUM,8,ZD)                     
/*                                                 


OUTPUT
Code:
1111122222CCCCCDDDDD
5555566666GGGGGHHHHH


Thanks,
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
PostPosted: Thu May 19, 2011 8:48 pm
 Reply with quote
SQLCODE1,

you never fail to provide an interesting post.

Do hope that Frank or Kolusu gives you an 'atta boy'.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
PostPosted: Thu May 19, 2011 10:39 pm
 Reply with quote
Quote:
Do hope that Frank or Kolusu gives you an 'atta boy'.


Indeed.

I've been quite pleased with the level of contributions of many of the posters to this Forum lately (e.g. escapa, vasanthz, sqlcode1, etc). Kolusu and I (being on the West Coast of the U.S.) get in "late" compared to others. It's nice to have many of the questions answered before we even get here. Gives us more time to develop future enhancements to DFSORT and ICETOOL.

I'd like to think that all of the documentation we've written, and solutions we've posted, over the years have contributed to the knowledge of DFSORT and ICETOOL displayed on this board. I congratulate the people who have made the effort to learn the product and help others.
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 Jul 09, 2012 2:28 pm
 Reply with quote
These ended up in the JCL forum in the middle of a DFSORT-turned-Syncsort topic, which later continued along different lines.

This is the original topic.
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 -> DFSORT/ICETOOL

 

Similar Topics
Topic Forum Replies
This topic is locked: you cannot edit posts or make replies. Urgent requirement for Credit Card pr... Mainframe Jobs 0
This topic is locked: you cannot edit posts or make replies. Urgent requirement for Credit Card pr... Mainframe Jobs 0
No new posts Immediate Onsite Singapore (Credit Su... Mainframe Jobs 0
This topic is locked: you cannot edit posts or make replies. MainFrame Professionals for Credit Su... Mainframe Jobs 0
No new posts Credit Card Processing CICS 5
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