Re: last insert
WIth what version can use DBINFO????? > Informix Guide To SQL -Tutorial Sept 1999, 4-32: > > Using the DBINFO Function > You can use the DBINFO function in a SELECT statement to find any of the > following information: > > - The name of a dbspace corresponding to a tablespace number or expression > > - The last serial value inserted in a table > ******************************************* > > - The number of rows processed by selects, inserts, deletes, updates, and > execute routine statements > - The session ID of the current session > - The name of the host computer on which the database server runs > - The exact version of the database server to which a client application is connected ¨ > > Thomas ------------------------------------------------------------------------ Gabinet Informàtic i Consultors Departament de Programació Josep M. Martí
"Josep M. Marti" <soft@gic.es> writes: > WIth what version can use DBINFO????? Don't know, but if you've got SERIAL you probably can use DBINFO to find last inserted SERIAL. Thomas
DBINFO is a 7.2x+ feature, earlier versions have to use the sqlca structure to find the last serial number. Art S. Kagel "Josep M. Marti" wrote: > > WIth what version can use DBINFO????? > > > Informix Guide To SQL -Tutorial Sept 1999, 4-32: > > > > Using the DBINFO Function > > You can use the DBINFO function in a SELECT statement to find any of the > > following information: > > > > - The name of a dbspace corresponding to a tablespace number or expression > > > > - The last serial value inserted in a table > > ******************************************* > > > > - The number of rows processed by selects, inserts, deletes, updates, and > > execute routine statements > > - The session ID of the current session > > - The name of the host computer on which the database server runs > > - The exact version of the database server to which a client application is connected ¨ > > > > Thomas > > ------------------------------------------------------------------------ > > Gabinet Informàtic i Consultors > Departament de Programació > Josep M. Martí