Oninit cdi / Archive
Talk to an expert →

Re: Getting serial value of just inserted record

Posted in 1997

Topics: Stored Procedures & SPL, Connectivity: ESQL/C, 4GL & Embedded SQL

Andre da Silva Nazare — — source: Informix-list mailing list archive (1991-1998)

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). In SPL you can use dbinfo(sqlerrd1), to know the value of the serial you almost inserted . > > > 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 | > > +--------------------------+-----------------------------+

Glossary