Removing duplicates from unique

Posted in 1997

Vince Pachiano — 3 Jun 1997 21:10:13 GMT — source: Informix-list mailing list archive (1991-1998)

Somehow some duplicate data "sneaked" into my database that should have a unique index constraint. Well, I have plugged the leaks, but now I am stuck with a database that I cannot re-index due to the duplicate data. How can I easily (AUTOMATED) remove the duplicate data? I can probably write some UNIX scripts to sort/sort -u, etc., but I was hoping there was a better way -- Vince pachiano@dayton.bassinc.com "Opinions expressed may not be correct--- But at least they're my own !!! ;-)