Re: Stored procedure problem

Posted in 1999

Vardan.Aroustamian@chase.com — Wed, 10 Feb 1999 10:44:01 -0500 — source: Informix-list mailing list archive (1991-1998)

Octav Chiriac <com@netinfo-moldova.com> wrote: > > > 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? I prefer to use method mentioned above, but anyway there is a place: select tabname, serialv from systables t, sysmaster:sysptnhdr p where tabname = 'your_table' and t.partnum = p.partnum; > > > > 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 > HTH also Vardan Aroustamian -- vaar@geocities.com