Running the Load

Load Mult 3

To run the Load, click on the Load button.

click on Abort to terminate the current load
click on Pause to stop the load after the current load completes

As the load runs you will be shown the progress of the load. In this:

Read - is the number of rows/lines read from the source
Loaded - is the number of rows succesfully loaded into the table
Dup - is the number of rows not loaded due to a Duplicate Row error
Error - is the number of rows not loaded due to another error.

Once the Load has completed

Click on Show Report File to view the report file, which has a summary of the load.

If a load has failed, click on the line in the grid. Another panel will be displayed. You will have options:

Show Error File - this will show you the errors the load encountered
Show Error Rows - this will show you the rows that were not loaded due to an error
Show Dup Rows - this will show you the rows that were not loaded due to a duplicate row error

You can use the Reset button to return the window to it's original state to rerun the load.

Table Selection

As you run the load, the tables are de-selected once they have been loaded. This is so that they will not be loaded a second time if you resume the load after it has been paused, or if you click on Load a second time.

Once the load has completed, all tables will be de-selected. If you wish to run the load a second time, click on Select > Select Tables used in last load (or Ctrl+L).

The Reset button will also re-select all the tables which were originally selected.

Advanced Query Tool

https://www.querytool.com