Replacing Existing Rows

somu_june · Post by **somu_june** » Thu Mar 16, 2006 9:02 pm

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

chulett · Post by **chulett** » Thu Mar 16, 2006 9:16 pm

The stage handles the delete/insert automatically so only one link is needed.

rasi · Post by **rasi** » Thu Mar 16, 2006 9:20 pm

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.