Re: Sequence numbers in Informix?

Posted in 1993

Dennis Pimple — 31 Aug 93 21:16:34 GMT — source: Informix-list mailing list archive (1991-1998)

robertr@apertus.com (Robert Randall) writes: >I am a new user to the Informix line of products. As usual, the manuals >are a bit cumbersome. Could someone please tell me if Informix has a >sequence number generation facility. For example, in Oracle, you can >create a sequence and perform a select against it that returns the next >unique seqence number. >Thanks in advance for the help! Informix supports a SERIAL datatype, which when inserted (with a value 0) will insert the next highest number no prevously used in that table. See the SQL manuals for more. ================ Dennis J. Pimple Informix CSE / Denver >-- >Robert Randall robertr@apertus.com >Apertus Technologies 612-828-0224 / 612-379-2678 >7275 Flying Cloud Drive Eden Prairie, MN 55344