RE: Unique identifiers

> Christian Hoj asked: > 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. Try using the datatype SERIAL(n) which stores a sequential integer assigned automatically by the datbase server when a row is inserted. Check out the Informix Guide to SQL (Syntax/Reference) for details. Cheers. Ralph. +-----------------------------------------------------------------------------+ | Never attribute to malice that which is adequately explained by stupidity. | +----------------------- ralph.halter@pac.panmail.com ------------------------+