Oninit cdi / Archive
Talk to an expert →

Informix sequence number generator

Posted in 1999

Topics: General Discussion

Kris Jakaran — — source: Informix-list mailing list archive (1991-1998)

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

↪ replying to Kris Jakaran
Hugues-Olivier Yar — — source: Informix-list mailing list archive (1991-1998)

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

↪ replying to Kris Jakaran
Andy McColl — — source: Informix-list mailing list archive (1991-1998)

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 > >

↪ replying to Kris Jakaran
Clifton M. Bean — — source: Informix-list mailing list archive (1991-1998)

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 > >