Howto retrieve serial field after insert?

Posted in 2000

Dan Sjuls — Wed, 27 Sep 2000 10:18:41 +0300 — source: Informix-list mailing list archive (1991-1998)

How do I return the data from a serial field after a insert in a stored procedure? insert into table (x_serial) values (0) Tanks

↪ replying to Dan Sjuls

Uwe Doetzkies — Wed, 27 Sep 2000 10:37:28 +0200 — source: Informix-list mailing list archive (1991-1998)

hi Dan Sjuls wrote: > > How do I return the data from a serial field after a insert in a stored > procedure? > > insert into table (x_serial) values (0) LET number = DBINFO ('sqlca.sqlerrd1'); hth uwe