Informix sequencing

Posted in 2000

DGO — Wed, 11 Oct 2000 15:02:59 -0400 — source: Informix-list mailing list archive (1991-1998)

I'm a bit new to Informix and need some help with how informix handles primary keys and sequencing. Oracle uses sequences and manages them using CURR_VAL and NEXT_VAL to manage record sequences. How does Informix handle this? Is it handled only by using a SERIAL or SERIAL8 datatype on tables? -Derek

↪ replying to DGO

Jonathan Leffler — Wed, 11 Oct 2000 12:45:24 -0700 — source: Informix-list mailing list archive (1991-1998)

DGO wrote: > I'm a bit new to Informix and need some help with how informix handles > primary keys and sequencing. Oracle uses sequences and manages them using > CURR_VAL and NEXT_VAL to manage record sequences. > > How does Informix handle this? Is it handled only by using a SERIAL or > SERIAL8 datatype on tables? SERIAL and SERIAL8 are the only ways to do this at the moment. There are rumours that 9.3 will have Oracle-compatible sequences. -- Yours, Jonathan Leffler (Jonathan.Leffler@Informix.com) #include <disclaimer.h> Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN "I don't suffer from insanity; I enjoy every minute of it!"