Joined: 18 Feb 2006 Posts: 812 Location: San Jose, CA
Posted: Tue Feb 03, 2009 9:41 pm Post subject:
Do you want to select records in which any of the 7-character strings from input file1 appear anywhere in input file2? Or are the "rules" something else?
What is the maximum number of records you can have in input file1 (e.g. 10? 100? 1000? 10000?). _________________ Frank Yaeger - DFSORT Development Team (IBM) - email@example.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
The following DFSORT/ICETOOL JCL will give you the desired results based on this assumption.
1. All your search strings in file 2 starts with a word "TBIGxxx".(we can modify to look for other strings also)
2. There can be only 1 occurance of TBIGxxx in your file-2 per record and it doesn't have any duplicates (we can handle duplicates also, let me know if you want to handle them also)
Brief explanation of the Job.
1.Step0100 - Copy the key contents from 80 byte file1 to pos 89 for 7 bytes and write to temp file t1
2.Step0200 - Use Parse to capture the 7 bytes starting with TBIG in your 88 byte file and put that at the end i.e pos 89 and write it temp file t2
3. Now concatenate these 2 files and any matching recording will be a dupe and since we only wanted the records from file 2 , we use the LASTDUP parm to get the desired results
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum