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
(
SELECT ID, PART_ID, AS OLD_ID
FROM FINAL TABLE
(
INSERT INTO SOME_TABLE
(
PART_ID
)
(
SELECT DISTINCT PART_ID
FROM SOME_TABLE
WHERE SOME_CONDITION
)
)
)
SELECT * FROM TEMP;