Hello,

I would like to know Identity OR sequence which is better?.

My requirement is simple. I have a parent table with ID (generated or
from sequence) and I want that ID after inserting parent record so
that I could use it for Child table(S).

I read in on the the thread ibm is planning to deprecate
identity_val_local() function in future. Appreciate the DB2 experts
advice.

Thanks,
Srini.