Page 1 of 1

To match and remove duplicate records from two files.

Posted: Fri Feb 06, 2009 1:40 pm
by abhishek_forum
Hello all,

I joined this forum recently.

I had one requirement.

I need to match two files and based on them I had write exception report

1. If the every record in fileA is not present in fileb,
2. if fileb contain any extra records,
3. if fileb contain duplicate records.

For first 2 req. I know I can use "IF MATCH FILEA FILEB"
But how to include 3rd condition with first two.

Please help me.

Regards,
Abhishek.

Duplicates

Posted: Fri Mar 27, 2009 5:10 pm
by Purusothaman
You can use

IF MATCHED
IF DUPLICATE fileb
.....
END-IF
END-IF