Re: Retrieving SERIAL identifiers in a concurrent environment

Posted in 2006

Bill — Mon, 2 Jan 2006 14:48:35 -0600 — source: Usenet: comp.databases.informix

My concern is "is it always correct"? Does the serial id come from that user's session in some buffer, or what? The manual says to get sqlerrd1 "immediately" after the insert. Hopefully that means "before another operation on the database by this program". Is that your understanding? >> SELECT DBINFO('sqlca.sqlerrd1') >> FROM systables >> WHERE tabname = 'systables' >

↪ replying to Bill

Clive Eisen — Mon, 02 Jan 2006 22:19:55 +0000 — source: Usenet: comp.databases.informix

Bill wrote: > My concern is "is it always correct"? Yes > > Does the serial id come from that user's session in some buffer, or what? It comes from the user session > > The manual says to get sqlerrd1 "immediately" after the insert. It means before that session does anything else to alter the structure > > Hopefully that means "before another operation on the database by this > program". > Quite -- Clive