Page 1 of 1

Replacing Existing Rows

Posted: Thu Mar 16, 2006 9:02 pm
by somu_june
Hi,

I want to use Replace Existing rows completely in update action. To achieve this do I need to have same value for key columms and I have only one link to the DB2 / API stage . How can have two links for delete and insert for single stage. Please help me how to achieve this option from transformer to DB2 stage.



Thanks,
Somaraju

Posted: Thu Mar 16, 2006 9:16 pm
by chulett
The stage handles the delete/insert automatically so only one link is needed.

Posted: Thu Mar 16, 2006 9:20 pm
by rasi
Somu

Under the stage plug-in General tab you have update action drop down box which list all the option available for you to choose. Read manual for detailed description of each option.