|
DB2 insert question |
Steve Terry
Member #1,989
March 2002
|
I have a simple table in DB2 with an identity column and I know I can do a select from final table on insert to get all of the new ID's for mass inserting new records from a select. However, I want to also be able to retrieve the old identity value as well in a separate column. Is this possible? WITH TEMP(ID, PART_ID, OLD_ID) AS ___________________________________ |
|