Insert Request Progress Dialog

During the Insert Process, the Insert Request Progress dialog displays status information.

Insert Request Progress dialog. The elements of the Insert Request Progress dialog are described as follows.

Totals

Rows to be processed
Total number of rows in the Source File to be processed.
Rows Inserted
Total number of rows that were inserted.
Rows Updated
Total number of rows that were updated.
Rows with Errors
Total number of rows from all the tables that have errors.

The totals in the Insert Request Progress dialog are revised after a number of rows are inserted for each table, after a number of seconds pass, and when the insert for one table completes and the process begins for the next table.

Note: The frequency with which the Progress dialog is updated (i.e., the number of rows and seconds) is specified on the Actions tab in Personal Options. (Refer to the Common Elements Manual ).

Current Table

Rows Inserted
Total number of rows inserted in the table.
Rows Updated
Total number of rows updated in the table.
Failed Rows
Total number of rows that could not be inserted and were discarded.

Cancel Process

To stop the process, click Cancel Process. A confirmation dialog is displayed:

Status Bar

Describes the action being performed and indicates the name of the table being processed, as applicable.

Process Time

Lists the elapsed process time for the Insert Process.

Cascading Delete/Update Confirmation

Archive performs a cascading delete/update check while processing an Insert Request.

After the cascading delete/update check is complete, Archive displays the Cascading Delete/Update Confirmation dialog if the following conditions are true:

  • The Warn on Cascade Delete/Update option in either Product or Personal Options must be set to Runtime or Always. (Refer to the Installation and Configuration Guide and the Common Elements Manual )
  • All Tables or Mixed must be selected for Delete Options on the General tab of the Insert Request Editor.
  • The cascade delete or update must affect at least one table that is not explicitly included in the Insert Process.

Click OK to continue processing the Insert Request, or click Cancel to stop processing and return to the Insert Request Editor.

For details on the Cascading Delete/Update Confirmation dialog, refer to the Common Elements Manual.