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.