Use the DB Alias tab to define the
specific parameters needed to perform the Load Process for the Informix® loader.
Mode
- Insert
- Insert rows from the Source File into empty destination
tables. If destination tables contain data, the loader returns an
error.
- Replace
- Clear all of the existing rows in the destination
tables and replace with the rows from the Source File.
Violation Table Options
- Start Violation Table
- Select this check box to issue a Start Violation
Table SQL statement. Check for previously linked violation tables
and diagnostic tables by clicking in the
menu. The Exception Table Mapping dialog displays.
Note: Archive
uses the terms violation table and exception table synonymously.
If linked tables are present, the Exception Table Map
is automatically populated with the table names. By default, a violation
table name is the table name with the suffix ‘_E'. (A diagnostic
table name has the suffix ‘_D'.) You can change the names of
the tables by overtyping them.
- Delete all rows
- Select this check box to delete all rows in existing
violation tables and diagnostic tables, before the Load begins.
Options
- Perform Load
- Select this check box to run the loader automatically
after file conversion processing is complete.
If
you clear this check box, the Load Process prepares the data in the
appropriate format and creates the BAT file to run the loader, but
does not initiate the loader. To run the loader, edit the BAT file
to include the proper password information and then run the BAT file.
- Delete files if Successful
- Select this check box to delete the data
files after the loader completes successfully. If you select this
check box, the Fast Load Confirmation feature is unavailable.
Note: Fast
Load Confirmation reduces processing time when you run a Load Request
that has run before. See
Process a Load Request for
detailed information.
- Delete files if Failure
- Select this check box to delete the data files if
the loader does not complete successfully. If you select this check
box, the Fast Load Confirmation feature is unavailable.
- Load When Source Is Empty
- Select this check box to perform the load if a table to be loaded
contains no rows. If you do not select this check box, any tables
in the Archive File containing no rows will be skipped in the load
phase. Using load with an empty source table deletes rows from the
target table, resulting in a clean test environment.
Commit
Specify
whether you want the loader to commit changes to the database by a
specified number of rows or one table at a time.
- To commit changes based on a number of rows, enter
the number of rows up to a maximum of 999999999.
- To commit changes after all data is loaded into
a table, specify zero (0) or leave blank. This method has advantages
when you want to ensure that either all data or no data is loaded.
Warning Limit
Specify
the number of rows, up to a maximum of 999999999, that the loader
can discard during the Load Process. The process stops when the specified
number of rows is discarded.
- To end the process if a single row is discarded,
specify 1 as the maximum.
- To set no limit to the number of rows that can be
discarded, specify zero (0) or leave blank.
Additional Loader Parameters
You
can augment the loader arguments created automatically by Archive
with additional loader parameters, if necessary. The additional parameters
you create are appended to the list created by Archive, but are not
validated by Archive prior to starting the loader. Refer to Informix documentation for
valid operands. If additional loader parameters are forced from within
Product Options, you cannot modify them. Refer to the Installation
and Configuration Guide.
Disable Triggers
- Never
- Select
this option if you do not want to disable database triggers for the
loader.
- Always
- Select this option to disable database triggers
during the Load Process and then re-enable the triggers after the
process completes.
- Prompt
- Select this option to display the Disabling
Trigger/Constraint Confirmation dialog. This dialog displays
a list of tables with all associated triggers. You can right-click
to enable or disable triggers during the Load Process for each table.
You can also select whether to enable or disable the triggers after
the Load Process completes.
Disable Constraints
- Never
- Select
this option if you do not want to disable referential integrity constraints
for the loader. When this option is selected, a warning message displays
when you run the loader.
- Always
- Select this option to disable referential integrity
constraints during the Load Process and then re-enable the constraints
after the process completes.
- Prompt
- Select this option to display the Disabling
Trigger/Constraint Confirmation dialog. This dialog displays
a list of tables with all associated constraints. You can right-click
to enable or disable constraints during the Load Process for each
table. You can also select whether to enable or disable the constraints
after the Load Process completes.
Note: Options to disable triggers and constraints apply
only when you select the Perform Load option.
The Disabling Trigger/Constraint Confirmation dialog
displays the list of tables in the Load Process and tabs that contain
the corresponding database triggers and referential integrity constraints
for each table.
A Focus Arrow in the first grid
column indicates the table for which triggers and constraints are
listed. To display the triggers and constraints for a different table,
click the first cell to reposition the arrow, or use the up/down arrows
on your keyboard.
Right-click
the Status During Process column to select
to enable or disable the corresponding trigger or constraint during
the Load Process. Right-click the Status After Process column
to select whether to enable or disable the trigger or constraint after
the Load Process completes.
Note: For Informix, you can also elect to enable constraints
with or without using a violation table. Select With Vio to
enable the constraint and use a violation table. Select No
Vio to enable the constraint and not use a violation table.
(If you select Enabled, the Informix default for violation tables applies.)
Workstation Path
Specify
a default directory path for storing the temporary loader files.