Re: Serial value in a Stored Procedure

Posted in 1994

Jim Gordon — 21 Feb 1994 12:58:04 -0500 — source: Informix-list mailing list archive (1991-1998)

> Is there a way in a stored procedure to get the value of the > serial field last inserted (like SQLCA.SQLERRD[2] in 4GL). > > | G.T.Madavan, | e-mail: gtmad@smi.mn.org | No, This missing feature is apparently fixed in V6 but in V5 you must remember an alternative business key and re-select the insert row to find the serial key. Cheers - Jim My opinions are my own. They may vary with time but they remain MINE! ---------------------------------------------------------------------- Name: Jim Gordon Internet: jgordon@ssf-sys.DHL.COM Company: DHL Systems Inc Phone: (415) 375-5222 (Work) Address: 700 Airport Blvd. #300 (415) 775-7762 (Home) Burlingame, CA 94010-1937 Fax: (415) 375-5019 ----------------------------------------------------------------------