To process a load request immediately, click .
It is not necessary to save the load request before it is run.
- Before processing begins, the request is verified.
If warning conditions exist, you can review the details in the Warnings dialog,
and choose to continue or cancel processing.
- During processing, if an error occurs, processing
stops.
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 names of the load request, source file, and
table map (named or local) match those used to generate the loader
files.
- The content of the source file has not changed since
the loader files were generated.
- Any column maps reference the same tables.
- The drive and directory for all loader files for
each table are the same as when the files were generated.
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.
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:
- The Warn on Cascade Delete/Update option
in either product or personal options is set to Runtime or Always.
- Replace mode (or truncate, for Oracle) and perform
load option are selected on the DB Alias tab
of the Load Request Editor.
- The cascade delete or update affects at least one
table that is not explicitly included in the load process.