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

Match and Unmatch file


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

Active User


Joined: 17 Nov 2009
Posts: 126
Location: India

PostPosted: Mon Jul 26, 2010 3:07 pm
Reply with quote

Hi ,

I have a problem, i have two input files of same rec length of 18. Both having product numbers ( 18 byte).

I have to create 3 output files as below,
1st- will have the products that present only in first input file.
2nd- will have the products that present only in second input file.
3rd- will have the products that presents in both the input files.

Pease guide. how to use icetool for it.

Thanks.
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Mon Jul 26, 2010 3:16 pm
Reply with quote

Though you did not tell if you have the keys at same place or not - however you can start from the parent topic "Create files with matching and non-matching records" Smart DFSORT Trick at: www.ibm.com/support/docview.wss?rs=114&uid=isg3T7000094 .
Back to top
View user's profile Send private message
Susanta

Active User


Joined: 17 Nov 2009
Posts: 126
Location: India

PostPosted: Mon Jul 26, 2010 4:32 pm
Reply with quote

Thanks alot Anuj. Very essential pdf.
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Mon Jul 26, 2010 4:43 pm
Reply with quote

Thanks to Frank and Kolusu. icon_smile.gif
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 How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Access to non cataloged VSAM file JCL & VSAM 18
No new posts Need help for File Aid JCL to extract... Compuware & Other Tools 23
Search our Forums:

Back to Top