Re: Informix Serial Data type to Integer Data Type

Posted in 2006

david@smooth1.co.uk — 10 Jan 2006 17:50:31 -0800 — source: Usenet: comp.databases.informix

Why update the serial field? It is mean to be just a unique identifier for each row. Stick a unique index on it and leave it alone. Instead update whatever references that field to use the correct foreign key value.