Re: How to get next serial value

Posted in 1997

Roberto Campo — Mon, 01 Sep 1997 18:58:10 +0200 — source: Informix-list mailing list archive (1991-1998)

Rory Reynoldson wrote: > > Quick question about Informix's serial datatypes (I'm used to working with > [...] You can use the function DBINFO with the parameter 'sqlca.sqlerrd1' to return the value of the last serial value inserted: i.e. select dbinfo(''sqlca.sqlerrd1') from ITAB (you must be sure that the select will return only one record including some Where clause). Informix suggest, to ensure valid results (?), to use this option immediately following the INSERT statement ... bye Roberto -- Roberto Campo Siemens Nixdorf Informatica S.p.A. +39 6 66393.409 Fax: 692 campo@scn.de