Run a Load Request

To process a Load Request immediately, click File > Run. It is not necessary to save the Load Request before it is run.

A progress dialog and status messages provide information while the request is processing. When processing completes, or stops because of an error, you can review the details in the process report. You can also browse the Control File to review process details.

Fast Load Confirmation

Fast Load significantly reduces processing time when you reuse a Load Request. The Fast Load Confirmation dialog displays if the following conditions are met:

If the Load Request, Source File, and Table Map names have changed, or the content of the Source File has changed, Archive cannot perform Fast Load for any table in the Load Request, and the Fast Load Confirmation dialog is not displayed.

If a Column Map name or the drive and directory for the loader files for a given table change, Archive cannot perform Fast Load for the table, and the table is not listed in the Fast Load Confirmation dialog.

Note: If you select Delete files if successful or Delete files if failure on the DBMS tab in the Load Request Editor, Fast Load is not available.
Fast Load Confirmation dialog

The Fast Load Confirmation dialog displays the Source file name, Table Map name or Local, and a list of the converted tables. A tab is displayed for each DB Alias.

Use the Fast Load Confirmation dialog to review the list of converted tables. To reuse all DBMS loader files for the tables listed, click OK. To create new DBMS loader files for any table, clear the check box for the table, and click OK. Click Cancel to stop processing and return to the Load Request Editor.

Note: You can right-click the grid and select commands from the shortcut menu to select or deselect all tables for the corresponding DB Alias. You can also use Select All or Deselect All to select or deselect all tables for all DB Alias tabs.