RE: Howto retrieve serial field after insert?
Try the DBINFO function, see Informix Guide to SQL Syntax for features and
examples.
-----Original Message-----
From: Ron M. Flannery [mailto:rflanner@speedlink.net]
Sent: Wednesday, September 27, 2000 5:50 AM
To: Dan Sjuls
Cc: informix-list@iiug.org
Subject: Re: Howto retrieve serial field after insert?
> How do I return the data from a serial field after a insert in a stored
> procedure?
>
> insert into table (x_serial) values (0)
Well in 4gl, you'd simply use the value of sqlca.sqlerrd[2]; I don't know
if it's available in a stored procedure. If not, try "select max(x_serial)
from table"..