We are using Identity Column as primary key in our
application. Since the Identity Column is defined as
Generated by default. Since DB2 will take care of the
generation of the primary key. The application team
now wants to know what value did DB2 inserted in the
Identity column since they have to insert that value
in the foriegn keys in the child table. There are
application that are coded in cobol and java also.
Is there a way to get the value from the table using
any function defined in DB2. If any of you in the
group has come up with a solution to handle this issue
and can help me will be just great.
Looking forward to help from the group.
Do You Yahoo!?
Send your FREE holiday greetings online!