Parameters Used for Deletes in Both the Header and Process Sections
This section describes the parameters that can appear in either the header section or a process section and are specific to a delete process. For generic parameters that can be used in all EIM processes, see Header Section Parameters Generic to All EIM Processes and Process Section Parameters Generic to All EIM Processes.
The following table provides descriptions of the parameters that can appear in the header and process sections of the EIM configuration file, and which are specific to delete processes.
| Parameter | Description |
|---|---|
CASCADE DELETE ONLY |
(Default = FALSE). Set this parameter to TRUE to delete child records with nullable foreign keys when the parent record is deleted. If FALSE, then when EIM deletes a parent record, it sets the foreign keys of the child records to NULL. |
CLEAR INTERFACE TABLE |
This parameter specifies whether existing rows in the EIM table for the given batch number should be deleted. Valid values are true (the default unless DELETE EXACT = TRUE) and false (the default if DELETE EXACT = FALSE). |
DELETE ALL ROWS |
Used for deleting all rows in table; default is FALSE. Note: Use this parameter with caution. For more information on this parameter, see DELETE ALL ROWS Parameter. |
DELETE EXACT |
Delete using user key matching algorithm with rows in EIM table; default is FALSE. For more information on this parameter, see DELETE EXACT Parameter. |
DELETE SKIP PRIMARY |
This parameter specifies whether EIM should perform a cascade update to the primary child column. The default value is TRUE. |
DELETE MATCHES |
SQL WHERE fragment deletion criteria. Example: DELETE MATCHES = EIM_ACCOUNT, (NAME LIKE “TST_ACCT%”). |
DELETE ROWS |
This parameter specifies whether rows from the target base table can be deleted. Valid values are TRUE (the default) and FALSE. This parameter can prevent deletions from one table while allowing them in others. For example, the following parameter setting prevents deletion of rows from the S_ADDR_ORG table:
Note: Use the FALSE setting
for DELETE ROWS carefully. Inappropriate use can result in dangling foreign key pointers. |
IGNORE BASE COLUMNS |
Specifies base table columns to be ignored by the import process. Use commas to separate column names, which can be qualified with base table names. Required and user key columns cannot be ignored. Use this parameter to improve performance when updating all but a few columns. The default is to not ignore any base table columns. |
UPDATE ROWS |
Specifies whether foreign key references can be updated. This parameter can be used to prevent the updating of foreign key references with a setting of FALSE. The default value is TRUE, which affects all tables. To affect only specific tables, you can specify a table name. For example:
The UPDATE ROWS parameter also prevents updates in one table while allowing them in others. If this parameter is set to FALSE, EIM does not update rows in the specified base table. If you need to specify multiple tables, use one UPDATE ROWS statement for each table. Note: Use the FALSE setting for UPDATE ROWS carefully.
Inappropriate use can result in dangling foreign key pointers. |