Re: Sequence numbers in Informix?

In article <CCMr99.29B@apertus.com> robertr@ns.apertus.com 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. } Informix allows for SERIAL data types. When you insert a record that has a 0 in the serial field into a table, Informix replaces that 0 with a unique sequence number. The sqlca.sqlerrd[2] variable contains the number assigned by the Informix engine. A reminder... sqlca.sqlerrd[2] for Informix-4GL sqlca.sqlerrd[1] for Informix-ESQL/C DAS -- David Snyder @ Snide Computer Services - Folcroft, PA Current Release is db4glgen-3.15 UUCP: ..!uunet!das13!dave INTERNET: dave.snyder@snide.com