MagarG
VIP Member
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
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