you may also need to create the database "sequence" (also called as sequence generator), this way the "sequence" will generate unique numbers(integers) for you.

-----Original Message-----
From: informix-list-bounces@iiug.org
[mailto:informix-list-bounces@iiug.org]On Behalf Of Sarat
Sent: Friday, January 06, 2006 5:51 AM
To: informix-list@iiug.org
Subject: Informix Serial Data type to Integer Data Type


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

_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list