DB2 how to get the last insert id from a table.

Question

Hi, i want to get the value of the last id insert in a table. How i can do this?

Answer 1

SELECT IDENTITY_VAL_LOCAL() AS VAL FROM SYSIBM.SYSDUMMY1

See docs.

Answer 2

Well the solution that i use is:

select id from NEW TABLE (insert into (val1, val2, ...) values ('lorem', 'ipsum', ...)

this get the id column from the last row inserted in the DB :)