Getting the value of a serial data type after inserting..

Posted in 2000

Topics: Stored Procedures & SPL, Data Types & Schema Design, Versions, Editions & End-of-Life

Elsa Perales — Wed, 19 Jan 2000 11:26:14 -0600 — source: Informix-list mailing list archive (1991-1998)

Hello: I'm working with IDS 7.31 under Windows NT I'd like to know how to retrive the value than a serial data type asigns when a new row is inserted to a table. Is there a way that I can return that value in a stored procedure? Elsa Perales Garza Grupo Internacional de Tecnologia e-mail: eperales@gint.con.mx

↪ replying to Elsa Perales

Chetan Anand — Wed, 19 Jan 2000 11:30:58 -0800 — source: Informix-list mailing list archive (1991-1998)

SELECT DBINFO( 'sqlca.sqlerrd2' ) FROM systables WHERE tabid = 1; This should be executed after each INSERT SQL before any other SQL. Rgds Elsa Perales wrote: > Hello: > I'm working with IDS 7.31 under Windows NT > > I'd like to know how to retrive the value than a serial data type asigns > when a new row is inserted to a table. > Is there a way that I can return that value in a stored procedure? > > Elsa Perales Garza > Grupo Internacional de Tecnologia > e-mail: eperales@gint.con.mx

↪ replying to Elsa Perales

Victor Vat — Thu, 20 Jan 2000 09:09:52 +0300 — source: Informix-list mailing list archive (1991-1998)

In stored procedure You may simply use: ... let last_serial_val = DBINFO( 'sqlca.sqlerrd2' ); ...

↪ replying to Victor Vat

Jay Buckler — Fri, 21 Jan 2000 20:16:07 GMT — source: Informix-list mailing list archive (1991-1998)

Actually, I think it is dbinfo('sqlca.sqlerrd1'). dbinfo('sqlca.sqlerrd2') returns the number of rows inserted/deleted/updated/selected. Jay Buckler Victor Vat <victor@rpolice.ru> wrote in message news:948345335.30000@grave... > In stored procedure You may simply use: > ... > let last_serial_val = DBINFO( 'sqlca.sqlerrd2' ); > ... > > >

↪ replying to Jay Buckler

Victor Vat — Sun, 23 Jan 2000 10:32:55 +0300 — source: Informix-list mailing list archive (1991-1998)

Yes, You are right ! The 'sqlca.sqlerrd1' option returns a single integer that provides the last serial value inserted into a table in current user session. And 'sqlca.sqlerrd2' option returns a single integer that provides the number of rows processed by SELECT,INSERT,DELETE,UPDATE and EXECUTE PROCEDURE statements. Jay Buckler wrote in message ... >Actually, I think it is dbinfo('sqlca.sqlerrd1'). dbinfo('sqlca.sqlerrd2') >returns the number of rows inserted/deleted/updated/selected. > >Jay Buckler

Glossary

IDS (Informix Dynamic Server)