Re: Unique identifiers

Christian Hoj <christian_hoj@saxotech.dk> wrote: :Hi there! :Does Informix have a built-in function to generate unique ID-numbers? I :need to be sure that I get a different number each time I call the :function, because the values are to be entered into a column with an :unique index. It sounds like you need to RTFM on the serial datatype. When this is defined you'll get unique numbers by inserting a 0 (zero) for that column. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org