Re: Informix Serial Data type to Integer Data Type

On 6 Jan 2006 03:51:11 -0800, Sarat <saratr@gmail.com> wrote: > We have 2 Java applications and some Esql/c scripts inserting/updating > data into Informix 9.30 Dynamic server tables simultaneously. At > present the Primary keys in these tables are of Informix Serial data > type. Now we are planning to change Serial data type to Integer data > type. May I know the possible (options/changes/any issues which may > occur) which need to be done for achieving the same? The only issue of note that I can think oof is that every application that currently inserts zero to generate the new serial number will have to be revised to determine the actual number to insert. Further, I'd probably want to put a 'dummy' row with ID of zero into the table (along with a unique index) to ensure that those inadvertantly overlooked applications all fail. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/