Suppressing Inserts

When the batch is a superset of an existing table, you should suppress inserts. For example, you may have a batch set of employee information that includes every individual in your organization. However, your Siebel database contains only members of the sales organization. To ignore batch entries for nonsales personnel in this case, you may want to run the entire batch using this setting to perform updates to existing rows only. If EIM attempts to insert a new row with this setting, the IF_ROW_STAT column is updated to NOT_ALLOWED. This means that EIM has attempted to insert a new row, but the action is not allowed.

To suppress insertions

• Set the INSERT ROWS parameter in the EIM configuration file to FALSE.

  The following example shows how to suppress insertions of unmatched rows from the EIM_ACCOUNT table to the S_ORG_EXT base table.

  [Import Accounts Details]
     TYPE = IMPORT
     BATCH = 1
     TABLE = EIM_ACCOUNT
     INSERT ROWS = S_ORG_EXT, FALSE