Informix sequence number generator
Kris Jakaran, new to Informix, asked how to generate sequential numbers automatically for an id field. Hugues-Olivier Yar, Andy McColl and Clifton Bean all pointed to the SERIAL data type. Clifton added that it can be seeded with a starting number (default 1) and referred to the Tutorial and Syntax guides. The answer was consistent; no reply from the poster.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Greetings all, i'm new to Informix and would like to know if there's the capability to automaticall generate sequential numbers for an id field in Informix. Any help will be appreciated. Thanks in advance
see "serial" data type. Kris Jakaran wrote: > > Greetings all, > > i'm new to Informix and would like to know if there's the capability to > automaticall generate sequential numbers for an id field in Informix. > Any help will be appreciated. Thanks in advance HugO
Set your id field to a type of serial. Andy Kris Jakaran wrote in message ... >Greetings all, > >i'm new to Informix and would like to know if there's the capability to >automaticall generate sequential numbers for an id field in Informix. >Any help will be appreciated. Thanks in advance > >
See the field type "serial", defined in the INFORMIX Tutorial Guide ... and in the Syntax Guide under "Create Table" (I think). You can seed it with a starting number. Serial(1) is the default setting. Both manuals are available online under http://www.informix.com/answers . You can also download them if you wish. Take care. =============================================== Clifton M. Bean cmbean@msn.com SAP/Informix Database Administrator Informix Certified Database Specialist Informix 4GL-Certified Informix D4GL-Certified Tekmetrics Certified Informix DBA Tekmetrics Certified RDBMS Developer =============================================== Kris Jakaran <kris.jaikaran@interaccesscorp.com> wrote in message news:fGVu3.75$pU2.2949259@dca1-nnrp1.news.digex.net... > Greetings all, > > i'm new to Informix and would like to know if there's the capability to > automaticall generate sequential numbers for an id field in Informix. > Any help will be appreciated. Thanks in advance > >