Update Mode

Because the update insert mode changes the existing data in the database, the following must be considered when using it:

• It is important that the user verify that all of the values specified in the configuration data worksheet are correct. Each field of a record in the database is updated using the values from the specified configuration data worksheet. Deleting a value in the configuration data worksheet causes the corresponding database table field value to be deleted for the given record.
• A single row in a configuration data worksheet may update multiple database records in the specified database table. The database fields specified in the update key column are used to select which record(s) in the database table to update. In some cases, the set of fields in the update key column do not match the primary key of the database table. The user must ensure that the selection criteria is correct so the configuration data updates are applied to the correct record(s).
• Some database tables, such as tables that contain only foreign keys to other database tables, cannot be updated using the data setup utility. The DSU generates an error message and stops processing when it encounters a database table that cannot be updated.
• If a record matching the configuration data cannot be found in the specified database table, the DSU does not update any records and does not report an error.