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

Given two files we need to extract the common records!!


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
gudfrnothin

New User


Joined: 04 Oct 2005
Posts: 1

PostPosted: Mon Oct 17, 2005 4:17 pm
Reply with quote

hi..

we are given two files frm which we need 2 extract only the common record. Suggest if any utility is there for the same or if it is to be done progamatically??

Tks,,
Back to top
View user's profile Send private message
priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1448
Location: Chicago, IL

PostPosted: Mon Oct 17, 2005 4:24 pm
Reply with quote

DFSORT's ICETOOL with ALLDUPS option will do the need....

Code:
//S010     EXEC PGM=ICETOOL                   
//TOOLMSG   DD SYSOUT=*                       
//DFSMSG    DD SYSOUT=*                       
//IN     DD DSN=RECORDS.INPUT1,DISP=SHR
//         DD DSN=RECORDS.INPUT2,DISP=SHR
//OUT    DD DSN=RECORDS.OUT,     
//          DISP=(,KEEP,DELETE),             
//TOOLIN DD *                                 
  SELECT FROM(IN) TO(OUT) ON(1,L,CH) ALLDUPS 
//


Where L = Length of the record.

Regards,

Priyesh.
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
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts Write line by line from two files DFSORT/ICETOOL 7
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Need help for File Aid JCL to extract... Compuware & Other Tools 23
No new posts Pulling a fixed number of records fro... DB2 2
Search our Forums:

Back to Top