Re: ESQL/C - Determining SERIAL value after INSERT

On Tue, 8 Sep 1998, Jake Colman wrote: > How do I determine the serial number assigned to my newly inserted record > using ESQL/C and without using the sqlca structure? I know how to check > sqlerrd[1] for the serial value when using the sqlca strcuture for exception > handling. Informix, however, recommend using the SQLSTATE method since that > is more portable and compliant with standards. So, using SQLSTATE how do I > get back the same information? Accessing the serial number isn't part of ANSI (because ANSI doesn't have serial numbers), so there isn't an ANSI-approved way of getting at the information. Use sqlca. Yours, Jonathan Leffler (jleffler@informix.com) #include <witticism.h> Guardian of DBD::Informix v0.60 -- http://www.perl.com/CPAN Informix IDN for D4GL & Linux -- http://www.informix.com/idn