Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Bashar Chalabi — — source: Informix-list mailing list archive (1991-1998)
This is how I do it:
I have a trigger on the insert. The trigger calls a procedure and
passes as an argument the serial number just inserted.
The procedure stores the serial number in a global variable
The global variable is then accessible from any other
procedure.
I may have a twisted mind, but it works. I have not
find anything simpler.
Bashar Chalabi
Card Tech Ltd
> vsp@triada.triad.com (Vaishali Padhye) writes:
> 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>
>
>
>
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.