File matching using splice and performance



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

File matching using splice and performance

Postby pacha » Sun Mar 21, 2010 10:55 pm

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.
pacha
 
Posts: 10
Joined: Sun Mar 21, 2010 10:27 pm
Has thanked: 0 time
Been thanked: 0 time

Re: File matching using splice and performance

 

Re: File matching using splice and performance

Postby Frank Yaeger » Tue Mar 23, 2010 10:53 pm

"A lot of time" is rather vague, but you could try using JOINKEYS instead of SPLICE. For complete information on DFSORT's JOINKEYS function, see:

http://www.ibm.com/support/docview.wss? ... g3T7000174
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: 1080
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 14 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post