IBM Mainframe Forum

Hi,

I am facing problem while comparing two files.

Myinput file:(filea)

UPN someotherfields
123457
345678
345678
345678
987654

fileb

UPN amount
123457 5678.00
234567 0001.00
345678 3421.00
987654 4573.00


the expected output will be:

UPN
123457 5678.00
345678 3421.00
345678 3421.00
345678 3421.00
987654 4573.00


i have used if matched statement. But the duplicate records in my input file is not written in my output file.

Is there any way to include all the duplicate records in my input file and write it in my output file?

Please anyone help me to resolve this ASAP?

Please anyone help me to resolve this ASAP?

unfortunately nobody here does ASAP !
we answer on our own time and free of charge
if You have urgency issues the best thing to do is to hire a paid consultant who,
for the proper fee, will be happy to provide the services You need based on Your time constraints

sameeha_basha wrote:[...]

Is there any way to include all the duplicate records in my input file and write it in my output file?

[...]

Yes. You have to have the correct logic in your program.

Please post your JOB statement and all the IF statements which relate to the file matching.

There is no way of doing this any faster than it just happens to go, except by you not waiting for us but concentrating on what the manual says.

You can combine the two approaches.

Are you using statements which deal with duplicates?

Hello and welcome to the forum.

For someone to help, you need to post your "match" code whether this is an IF MATCHED or some of your own code.

You probably want to read about IF DUPLICATE in the documentation.