Search string using ICETOOL or DFSORT



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

Search string using ICETOOL or DFSORT

Postby radhika_engimuri » Wed Nov 11, 2009 4:04 pm

Hi

I have a requirement to separate records from input file based on a string (Not constant)

I have two input files - one file having record with a string and another input file with multiple records

Input file 1

0001AAAAAAA --- This AAAAAAA can be any string (it is not a constant). Now I want to search in File2 with this string to find records that match the string and want to separate out matched records into another file

Ex: If AAAAAAA = 8765432 ---- this is an example, I dont have any clue what value varialbe AAAAAAA holds exactly

Input file 2

00016543217
00026543217
00036543217
00048765432
00058765432
00068765432

My output should look like

00048765432
00058765432
00068765432


Thanks in advance,
Radhika
radhika_engimuri
 
Posts: 7
Joined: Thu Jan 08, 2009 6:06 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Search string using ICETOOL or DFSORT

 

Re: Search string using ICETOOL or DFSORT

Postby Frank Yaeger » Wed Nov 11, 2009 11:19 pm

What is the RECFM and LRECL of your input file?

What is the starting position and length of the string in input file1? Does it start in position 5 after the 0001, or is the 0001 really not in the record, so the string starts at position 1?

Is the 0001, 0002, etc really in input file2?
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