Re: SERIAL: how to SELECT generated number?

Posted in 1997

"Timothy M. Hood" — 17 Mar 1997 04:43:32 -0500 — source: Informix-list mailing list archive (1991-1998)

Andreas Schubert wrote: > > Is there a way to get by SELECT statement the content of SQLERRD[2] -- the > generated serial number after INSERT? (not in ESQL environment, must be > single SQL query). I'm not sure why you don't just reference SQLCA.SQLERRD[2]. Otherwise, you can fetch the serial number column from the table you just inserted into. You said no ESQL, but didn't say whether 4GL or ISQL or what.