Hello, Anyone has an idea on how to get last inserted id in DB2? I have two tables in db2, one child, one parent. I would like to insert data into one table, and get the id (which auto generated in the db2,) then insert the id into another table as a foreign key. Thanks.
Hi jlolling, Thanks for taking time to answer my question. Do you mean get the new id before insert any data into the first table? My table is an existing table, and id is designed to auto-generated by database. I don't think I can change it now. If I misunderstood your meaning, could you please explain a little bit more. Thanks!