Re: Informix Serial Data type to Integer Data Type

Posted in 2006

Paul Watson — Sun, 08 Jan 2006 12:00:46 -0600 — source: Usenet: comp.databases.informix

Sarat 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? > > Thanks in advance > Sarat > saratr@gmail.com > You sure you really want to do this, you are going to have to manage the key yourself. That aside, the alter table will do want you want Paul Watson