getting serial number after insert

soneliso · #1 (**permalink**) 09-05-07, 04:41

Hi

I new to informix, but i trying to get serial number after performing an insert statement.

Thanks

Tyveleyn · #2 (**permalink**) 09-05-07, 10:06

Hi, within one session you can do the insert and retrieve the last inserted serial value with:

Code:

INSERT INTO serialtest VALUES(0, 'Mickey', 'Mouse');     
SELECT DISTINCT dbinfo('sqlca.sqlerrd1') FROM serialtest;

Regards

soneliso · #3 (**permalink**) 09-05-07, 10:19

Thanks

I am sure it works the same way as this one, SELECT DBINFO('SQLCA.SQLERRD1') as serialid FROM systables WHERE tabname = 'mytablename'

Thanks again for the reply i really appreciate it

Internet Services

Web Development

Digital Marketing

Consumer Tech