Figure 9: Returning generated identity value and original 3 column key

 
SELECT keyval,keypt1,keypt2,keypt3
  FROM FINAL TABLE ( INSERT INTO table_new (otherdata)
                     INCLUDE (keypt1 INT,keypt2 INT,keypt3 INT)
                     SELECT otherdata, keypart1, keypart2, keypart3
                     FROM table_old )