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.
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 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.
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.