Process Section Parameters Used for Deletes

Parameters in the process section apply only to that specific process and override any corresponding value in the header section for the specific process. This section describes the parameters used in the process section that are specific to a delete process. For generic parameters that can be used in all EIM processes, see Process Section Parameters Generic to All EIM Processes.

To delete data, you must define at least one process with TYPE = DELETE.

If the process is defined with TYPE = DELETE, the DELETE ROWS parameter will be automatically set to TRUE. In some cases, you may not want to delete data from a nontarget base table as a result of cascade action. In this case, use the DELETE ROWS parameter to prevent deletion of rows from a specified table. The following example contains lines that can be used in the EIM configuration file to define a delete process for the accounts table while preventing rows from being deleted in the S_ADDR_ORG table.

[Delete Accounts]
  TYPE = DELETE
  BATCH = 200
  TABLE = EIM_ACCOUNT
  DELETE ROWS = S_ADDR_ORG, FALSE
  DELETE EXACT = TRUE
  ONLY BASE TABLES = S_ORG_EXT