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

Posted in 1995

Rob McAllister — Thu, 23 Nov 1995 02:00:09 GMT — source: Informix-list mailing list archive (1991-1998)

What version of ONLINE are you using? If it is 5.x, there is no way to get this in an SPL, except to re-read the record just added by an alternate unique key. vsp@triada.triad.com (Vaishali Padhye) 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 >4gl or esql program, can this structure be accessed in a stored >procedure? Any pointers will be a great help. Thanks! >Vaishali Padhye >Triad Systems Corp. >#include <std_disclaimer.h>