Re: Unique Keys on Corrupt Serial Fields

Posted in 1994

Mike Dwyer — 22 Sep 1994 19:21:28 GMT — source: Informix-list mailing list archive (1991-1998)

In article <35sam1$lmq@krel.iea.com>, Scott Clark <scottc@comtch.iea.com> wrote: >I have a customer who (somehow) got duplicate values in a SERIAL field >that is keyed uniquely. I need to figure out a way to rebuild his data >file and make the values in the SERIAL field unique. I have tried Assuming you do not need to retain the existing serial values (where they ARE unique), you could unload the data, using SELECT "0" for the serial column. Delete the current rows and load from the unload file. Informix will supply your unique serial keys for you! miked