Insert Request

The Insert Request Editor dialog allows you to select parameters for processing the Insert Request, including the following:

You can choose to run the Insert Request immediately or schedule the request for later processing.

Process Options

Insert
If the primary key value is unique to the destination table, the new row is added to the destination table. If the primary key value is not unique to the destination table (the row already exists), the row is discarded. Move uses a Control File to keep track of discarded rows so that you can review them and possibly reprocess them later.
Update Only
If the primary key of a row in the source data matches the primary key of a row in the destination table, the row is updated. If the primary key of a row in the source data does not match the primary key of a row in the destination table, the row is reported as failed.
Update/Insert
If the primary key value is unique to the destination table, the new row is added to the destination table. If the primary key value is not unique to the destination table (the row already exists), the row in the Extract File replaces or updates the existing row.
Mixed
Move also allows a mix of insertion methods where some tables are inserted and others are updated.

Object Definitions

If destination tables do not exist, Move can generate the SQL to create the tables from the object definitions contained in the Extract File─either as part of the Insert or as a separate step. In addition to tables, other object definitions can be created.