Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Dave Snyder — — source: Informix-list mailing list archive (1991-1998)
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.