Re: Getting value of serial column after insert inside stored procedure, help!

Posted in 1995

Dennis Pimple — 22 Nov 1995 17:50:14 GMT — source: Informix-list mailing list archive (1991-1998)

Vaishali Padhye (vsp@triada.triad.com) wrote: : Hi, : I am inserting a record in a stored procedure for a table having : a serial column, now I want to find out the value the serial : column got assigned and return it. : I know it gets assigned in sqlca.sqlerrd[1], but thats useful in ^ you mean 2 : 4gl or esql program, can this structure be accessed in a stored : procedure? Any pointers will be a great help. Thanks! See dbinfo() in INFORMIX GUIDE TO SQL: SYNTAX if you're running version 6.0 or greater (and some later versions of 5.x, maybe). If running an earlier version, see the FAQ or ask nicely and I'll send you the lengendary "DDD kludge". : Vaishali Padhye : Triad Systems Corp. : #include <std_disclaimer.h> -- ======================================================================= Dennis J. Pimple dennisp@informix.com Opinions expressed Principal Consultant -------------------- are mine, and do not Informix Software Inc Voice: 303-850-0210 necessarily reflect Denver Colorado USA Fax: 303-779-4025 those of my employer.