Re: Getting serial value of just inserted record

Dragi Raos wrote: > > AndreasSeibt wrote: > > > > I have to write a stored procedure which inserts a record into a table. > > This record has a field of Type SERIAL as primary key. I need the value of > > the primary key directly after inserting the record for subsequent > > processing. Is there any way to get this value? > > > > I use INFORMIX-Online 7.23. > > > > Many thnks for your help > > > > Andreas > > sqlca.sqlerrd[1] (C syntax), SQLCA.SQLERRD[2] (NewEra and, presumably, > 4GL). Some development tools have their own syntax (e.g. JAM & Prolifics > @dmserial). > > HTH > > Dragi "Bonzi" Raos > > +--------------------------------------------------------+ > | 4-MATE Information Engineering Inc. | > +--------------------------+-----------------------------+ > | 4-MATE | Tel: +385 (1) 242-116 | > | Kosa bb | +385 (1) 242-126 | > | 10000 Zagreb | Fax: +385 (1) 242-121 | > | Hrvatska (Croatia) | e-mail: bonzi@4mate.hr | > | | URL: http://www.4mate.hr | > +--------------------------+-----------------------------+ Oops, sorry, you said 'stored procedure'! I don't know and couldn't find. Sorry for wasting time & bandwidth! Bonzi