Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
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
- Set the delete exact parameter in the EIM configuration file to true; its default value is false.
- 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_POSTNNOTE: 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:
Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
Siebel Enterprise Integration Manager Administration Guide Published: 05 January 2004 |