FILEMATCH bw two files based on a field using ICETOOL



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

FILEMATCH bw two files based on a field using ICETOOL

Postby archana_p85 » Sat Dec 13, 2008 6:52 pm

Hi ,

I want to do FILEMATCH between two files based on particular field. i want all the matching records from FILE2(including duplicate records).i used splice for the same.But duplicate records are also removed.in there any option in icetool to keep duplicate records.

for EX:
FILE1
6335409900000000416
6335409900000000515

FILE2
6335409900000000416
6335409900000000416
6335409900000000416
6335409900000000515
archana_p85
 
Posts: 6
Joined: Sat Dec 13, 2008 6:44 pm
Has thanked: 0 time
Been thanked: 0 time

Re: FILEMATCH bw two files based on a field using ICETOOL

Postby Frank Yaeger » Sat Dec 13, 2008 9:52 pm

Since you didn't show your SPLICE job or your expected output, I can only guess at what you need.

However, I suspect the SPLICE operand you're looking for is WITHALL.

For complete information on the SPLICE operator of DFSORT's ICETOOL, see:

http://publibz.boulder.ibm.com/cgi-bin/ ... 0528171007

Also, see the "Create files with matching and non-matching records" Smart DFSORT Trick at:

http://www.ibm.com/systems/support/stor ... vs/tricks/
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times

Re: FILEMATCH bw two files based on a field using ICETOOL

Postby archana_p85 » Sun Dec 14, 2008 10:14 am

yes WITHALL is wrking.
Thank you so much Frank
archana_p85
 
Posts: 6
Joined: Sat Dec 13, 2008 6:44 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post