Re: Informix Serial Data type to Integer Data Type
This is a discussion on Re: Informix Serial Data type to Integer Data Type within the Informix forums, part of the Database Server Software category; --> On 1/8/06, Savio Pinto (s) <spinto@cap.org> wrote: > you may also need to create the database "sequence" (also called ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-20-2008, 10:04 AM
| ||||
| ||||
 Re: Informix Serial Data type to Integer Data Type On 1/8/06, Savio Pinto (s) <spinto@cap.org> wrote: > 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. Yes, but only in IDS 9.40 and above. That's why I didn't mention them - though maybe I should since IDS 9.30 is ony marginally supported any more, and Sarat should, ideally, upgrade from 9.30 to 10.00. > -----Original Message----- > From: informix-list-bounces@iiug.org On Behalf Of Sarat > > 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? -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/      |
Linear Mode
