Search found 1 match
- Wed Nov 17, 2010 1:41 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need to Update and insert at the same time
- Replies: 1
- Views: 915
Need to Update and insert at the same time
Hi , I have a req for For a customer C1 ,which is already present in the target table and when the same customer C1 comes in with some change in attribute. i need to Update the existing C1 record (changing the EFF_DT and the EXP_DT) AND Inserting a new row as C1 with new eff_dt and exp_dt. Can we ac...