IBM Mainframe Forum

Hi ...

I have two input files

1st Input files is sorted and contains duplicates

2nd Input file is not sorted and it does not contain duplicate.

I want to compare 1st file with second file and write (matched records) and (unmatched records of file1) in two different files

Can I do it through If matched logic in Eazytrieve... Will i get any errors as the 2nd file is not sorted.

input file 1
a12345
b11555
a12345
c15151
d54545


input file2

z12345
a12345
b11555
c45545
e465456



I need quick reply and it is very urgent,

Hello,

If you believe you have an urgent issue, the forum is Not the place to go. There is no guarantee that an answer will be posted quickly or even at all . . .

You need to sort the unsorted data and then match the files.

gyt3,

For Synchronised File Processing both the files need to be in sequence if you hope to match anything sensibly.

If you have duplicates on one file, and no duplicates on the other, make the no-duplicates file the FIRST file. You'll find it much easier to deal with the match that way.

Hmmm, seems my posts were deleted. Probably a technical glitch.

Hello,

No, no glitch.

We routinely review topics and remove posts that do not (or no longer) contribute to the "solution". I've deleted more than 500 of my own replies over time . . .

d

Yes, just zapped one of my own from the thread, as no longer "attached" to anything. We do try to keep threads "manageable" for people doing their own research for a particular problem.

Yea, okay.
Well, whoever works on a "solution" note that the original poster 'input file 1' example data is not in sorted order.

gyt3 wrote:1st Input files is sorted and contains duplicates