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

Deleting All Data Rows

If you want to delete all data rows in a target base table, you must perform the following procedure. Typically, this would only be performed in a test environment.

To delete all rows in a target base table

• Set the delete all rows parameter in the EIM configuration file to true; its default value is false.

  The following example contains lines that can be used in the EIM configuration file to delete all rows from the accounts table:

  [Delete Accounts]
  TYPE = DELETE
  BATCH = 200
  TABLE = EIM_ACCOUNT
  DELETE ALL ROWS = TRUE

CAUTION:  Use the DELETE ALL ROWS = TRUE setting with extreme caution. It will indeed delete all rows in the target base table.