Change in update processing using "Update rows with the value for the key"

Magic 3.2.0

To date, when updating data for PostgreSQL or SQLite3, the internal process separately executed an INSERT statement and an UPDATE statement in two requests. In DataMagic Ver.3.2.0 or later, in order to improve the performance of updates to the database system, the process was changed to execute INSERT and UPDATE in a single request.

In accordance with this change, when "Update rows with the value for the key" is selected for "Update method" on the Database Table - Detailed Information screen, data processing fails if all of the following conditions are not met:

• A PRIMARY KEY is defined on a key column in the database system.

• The PRIMARY KEY in the database system matches the "Key" field on the Database Table - Detailed Information screen.