Re: How do I obtain the last serial number inserted into a table?

There is a internal record in Informix called SQLCA that will give you this information. I do not have the manuals with me, but you will find it in either the 4GL or SQL manuals under SQLCA. Regards Dirk EKWAK <ekwak@encoredev.com> wrote in article <3buX.2235$SK2.17768483@news1.jacksonville.net>... > How can I properly obtain the last serial number that was inserted into a > table with a serial column bearing in mind that there will be concurrent > users inserting into this same table? Is the call to the dbinfo function the > only way other than doing a select max( xx) from the table? Is there a > global variable that can be used? I know in Oracle you can select > name_seq.nextval before hand and then use this number however you like. > > >