VERIFIED SOLUTION i

How to remove duplicate records from a file code that are remaining in the mail output file using Merge/Purge Plus

Product affected:  Merge/Purge Plus 6.6.0
Product Feature: General
Operating System: WIndows, UnIx/Linux and IBMi

 
Using one file that has 2 file codes:
6 records to file code A – Not marked as a purge file or treated as a multi-buyer.
246 records file code B.
The FLCnnn Parameter for file Code B has a purge file code.
P in position 18, P -  No record with this file code will be written to the mail files (files MPPMAIL and MPPEXTRA).
 
All records have the same address and are being treated as Resident.
Why are 4 records from file code B going to the Mail output file when they are duplicates to the other records in File Code B?
 
In the parameter setup, the SUROPT parameter has a D in position 10:
Mail File Drop Options
D - Exclude all records involved in duplication.
 ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+
SUROPT E D
 
Once this is changed to N:
N - Exclude non-multi-buyer records. 
....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+
SUROPT E N

Then none of the file code A records were written to the mail output file.
This worked for this particular input file and parameter setup.  Each job is unique and may not work in every scenario.

Also consider and verify the Match field(s), and CMPFLD (if used), are correct for the job's purpose. 
 
 
UPDATED:  December 18, 2017