IBM Mainframe Forum

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

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/

yes WITHALL is wrking.
Thank you so much Frank