Suppressing Updates

When the information in your database is already accurate and current, you should suppress updates. For example, opportunities and associated contacts might appear as a batch feed from an external application on a regular basis. You may only be interested in adding new opportunities while preserving the information in existing opportunities. Use the UPDATE ROWS = FALSE statement to preserve existing information.

Caution: Because suppressing updates prevents updating primaries in Step 10 in EIM Import Process, this setting should be used with caution.

To suppress updates to existing rows

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

The following example shows how to suppress updates to existing rows in the S_ORG_EXT base table.

[Import Accounts Details]
   TYPE = IMPORT
   BATCH = 1
   TABLE = S_ACCOUNT_DTLIF
   UPDATE ROWS = S_ORG_EXT, FALSE