Informix Serial Data type to Integer Data Type

Posted in 2006

Sarat — 6 Jan 2006 03:51:11 -0800 — source: Usenet: comp.databases.informix

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? Thanks in advance Sarat saratr@gmail.com