Re: last insert

On Wed, 28 Jun 2000, Obnoxio The Clown wrote: > >OK! Lets say I inserted a row, which has a SERIAL data column (and some > >other > >columns), which is autoincremental, and I insert a 0! How do I get the > >number > >that Informix put in that column to reference that row on another table? > > OK! Let's say I refer you to http://www.informix.com/answers, because that > really is an RTFM question. Been there. Found nothing in this relate. :-( "And I'm happy, because you make me feel good, about me." - Melvin Udall ----------------------------------------------------------------- Mart'n Marqu's email: martin@math.unl.edu.ar Santa Fe - Argentina http://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -----------------------------------------------------------------

"Martin A. Marques" <martin@math.unl.edu.ar> writes: > On Wed, 28 Jun 2000, Obnoxio The Clown wrote: > > > >OK! Lets say I inserted a row, which has a SERIAL data column (and some > > >other > > >columns), which is autoincremental, and I insert a 0! How do I get the > > >number > > >that Informix put in that column to reference that row on another table? > > > > OK! Let's say I refer you to http://www.informix.com/answers, because that > > really is an RTFM question. > > Been there. Found nothing in this relate. :-( Go back there;) 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