COEXISTENCE - Cleaning up Duplicate Records

We are ending Coexistence. We have two files, F1307 (Work Order Status History) and F43199 (PO Detail Ledger Audit) files that have over 25000+ duplicate records in them. We can run a SQL query using STRSQL to identify them:

SELECT F1TREC, F1NUMR, F1EFTB, F1BEGT, F1EWST,
COUNT(*) AS "NUM OF DUPS"
FROM PRODDTA/F1307
GROUP BY F1TREC, F1NUMR, F1EFTB, F1BEGT, F1EWST
HAVING (COUNT(*) > 1)

With the other files that had duplicates, we used DFU to clean them up since there weren't that many. This is not feasible with these two. Anyone have mass methods for cleaning these up.

Thanks, Grant

I have run into this on a few occasions, usually we just did a select distinct into a fresh table, cleared the JDE table and brought back the now unique records.

Not pretty, but it works. The only problem I saw was with some of the logging data within the tables, like program, user, date changed.... Sometimes, we deleted the last record changed instead of the older one, but the only issue with that was the auditors did not like it.

You can also make a backup of the pre change table and provide the auditors with that if they *itch too much.

K

F43199 will be cleaned up during the Application Conversions. Just make sure to run the DB Analyzer before doing the DB Copy to double-check this.