Re: SERIAL: how to SELECT generated number?

Posted in 1997

Andrei Shirobokov — Mon, 17 Mar 1997 17:07:36 -0800 — 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). > Thanx. > -- > ,,Perfection is achieved only in the point of collapse." (C.N.Parkinson) > > Andreas Schubert, mailto:aschub@sax.sax.de It seems to me it's impossible to use SELECT in the case...You can receive the content of SQLERRD[2] in any variable of INTEGER type...