I am using ICETOOL SPLICE operator to delete records from file A, if it matches certain fields of records in file B.
File A
EMPNO NAME COUNTRY
111 RAJU INDIA
222 SHYAM JAPAN
333 RAM INDIA
444 SWA CHINA
FILE B
TOTAL-EMP COUNTRY
50 INDIA
60 CHINA
Records in file A should be delted if country matches in both files. I was able to resolve this using SPLICE, KEEPNODUPES and KEEBASE. But the problem is my file A is having millions of records. But even if my file B is empty or having few records, splice takes a lot of time to execute. Please help me out to resolve this.