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:

The Fast Load Confirmation dialog is not displayed when:
  • The load request, source file, and table map names have changed, or the content of the source file has changed. Fast load is not performed for any table.
  • A column map name or the drive and directory for the loader files for a table change. Fast load is not available for the table
  • 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 for any table.
Fast Load Confirmation dialog

The Fast Load Confirmation dialog displays the source file name, table map name or Local, with a list of the converted tables. A tab is displayed for each DB alias. You can right-click the grid and select commands 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.

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.

Cascading Delete/Update Confirmation

The Optim™ solutions perform a cascading delete/update check while processing a load. After the check, the solution displays the Cascading Delete/Update Confirmation dialog if:



Feedback