Page 1 of 1

FILEMATCH bw two files based on a field using ICETOOL

PostPosted: Sat Dec 13, 2008 6:52 pm
by archana_p85
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

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

PostPosted: Sat Dec 13, 2008 9:52 pm
by Frank Yaeger
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/

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

PostPosted: Sun Dec 14, 2008 10:14 am
by archana_p85
yes WITHALL is wrking.
Thank you so much Frank