Re: Stored procedure problem

Posted in 1999

Octav Chiriac — Wed, 10 Feb 1999 09:53:50 +0200 — source: Informix-list mailing list archive (1991-1998)

You can use the dbinfo('sqlca.sqlerrd1') function to retrieve the last generated serial value after an INSERT. Hope this help, Octav On Wed, Feb 10, 1999 at 03:07:19PM +0800, Organo, Norman wrote: > 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 -- Octav Chiriac Phone: (373) 2 21 20 96 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 24 00 83 Moldova, Republic of mailto:com@netinfo-moldova.com