Running the D&B Update Manager (D&B) Process Without Updating or Deleting Existing Data

Depending on your business process, you might want to run the D&B Update Manager (D&B) server component without updating or deleting any existing data in the S_DNB_ORG table. You edit the RTI configuration file to perform this task.

To edit the RTI configuration file so that existing data in the S_DNB_ORG table is not updated or deleted

1. Open the RTI configuration file (dnbmaps.sql for single task or dnbmaps.tsq for multiple task) in a text editor.

2. Search for the UPDATE_DNB_ACCOUNT section under [Common] heading.

3. Modify the section to look like the following:

   UPDATE_DNB_ACCOUNT.Function = NONE
   UPDATE_DNB_ACCOUNT.MOD1TABLE = S_DNB_ORG
   UPDATE_DNB_ACCOUNT.MOD1WHERE = WHERE 1 = 1
   UPDATE_DNB_ACCOUNT.MOD1INSERT = TRUE
   UPDATE_DNB_ACCOUNT.MOD1UPDATE = FALSE
   UPDATE_DNB_ACCOUNT.MOD1DELETE = FALSE
   UPDATE_DNB_ACCOUNT.MOD1TXNLOG = FALSE
   

   If you are using the default file, then only change UPDATE_DNB_ACCOUNT.MOD1UPDATE from TRUE to FALSE.

4. Save and close the file.