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.