How to eliminate inserting Duplicate rows into database using JDBC Adapter

[#1]

File->Xi->JDBC

In above Scenario if the file has two rows their values are identical, then how can we eliminated inserting Duplicate rows into database using JDBC Adapter

[Former Member]

Hi Venkatesh,

usually the DB handels that for itself, you cant insert 2 same rows as the keys would be same as well. You would get an error.

To avoid getting errors use action UPDATE_INSERT, double entries are now ignored.

<a href="http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm">Document Formats for the Receiver JDBC Adapter</a>

Regards,

Udo