DUPLICATE KEYS

Posted in 1994

sheltra@emh-1.submepp.navy.mil — 28 Oct 1994 11:23:09 -0400 — source: Informix-list mailing list archive (1991-1998)

Thanks again for the response to my duplicate keys problem. The following was the solution to my problem. 1. I did a dbunload. 2. With UNIX I sorted the table dropping duplicates. 3. I deleted the original table. 4. Re-created the index on the key. 5. Reloaded the sorted table with dbload. I was fortunate that the non-key data was also duplicated.