Siebel Enterprise Integration Manager Administration Guide > Deleting Data > Editing the Configuration File for Delete Processing >

Deleting Data Rows Identified by User Key Values

You must complete the following procedure to delete rows identified by user key values.

To delete rows with user key values appearing in the EIM tables

1. Set the delete exact parameter in the EIM configuration file to true; its default value is false.
2. Add the ONLY BASE TABLES parameter and set this parameter to the name of the base table you want to delete.

   The following example contains lines that can be used in the EIM configuration file to delete rows with user key values in the EIM tables from the Accounts table:

   TYPE = DELETE
   BATCH = 200
   TABLE = EIM_ACCOUNT
   DELETE EXACT = TRUE
   ONLY BASE TABLES = S_ACCNT_POSTN

NOTE:  Although you can use the DELETE EXACT parameter to delete rows from both target and nontarget base table, you should only use it to delete nontarget base tables that contain user keys. Rows in nontarget base tables that do not contain user keys will not be deleted.

Rows from the following tables do not have primary user keys and thus cannot be deleted using this parameter:

• Notes
• Territory Items
• Fulfillment Items