Re: Stored procedure problem

Posted in 1999

Sujit.Pal@BankAmerica.com — Wed, 10 Feb 1999 09:03:02 -0800 — source: Informix-list mailing list archive (1991-1998)

Norman You can get the serial value inserted in a stored procedure like so: INSERT INTO sometable VALUES (0, -- corresponds to serial col. ...);LET serialval = DBINFO('sqlca.sqlerrd1'); HTH Sujit "Organo, Norman" <Norman_Organo@online.com.ph> on 02/09/99 11:07:19 PM To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: Stored procedure problem Hi Informix-list, How do you get the newest/highest value of a serial column inside a stored procedure? I remember that a certain system catalog table is used to store this. Can anyone tell me what table that is? Norman