Optim™ supports the Informix® loader. Use the DB
Alias tab to define the specific parameters needed to
perform the Load Process.
Mode
- Insert
- Inserts rows from the Source File into empty destination
tables. If destination tables contain data, the loader returns an
error.
- Replace
- Clears all of the existing rows in the destination
tables and replaces with the rows from the Source File.
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 Extract 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.
To create a
clean test environment:
- For an existing target table, use
- Load When Source Is Empty
- an empty source table
- Replace mode
- For a newly created table, use
- Load When Source Is Empty
- an empty source table
- Insert mode
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.
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 to
display the Exception Table Mapping dialog.
Note: The
terms violation table and exception table are used synonymously in Optim.
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 over-typing them.
- Delete all rows
- Select this check box to delete all rows
in existing violation tables and diagnostic tables, before the Load
begins.
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
This
field is provided to allow you to augment the loader arguments created
automatically by Optim with
additional loader parameters, if necessary. The additional parameters
you create append to the list created by Optim, but are not validated by Optim prior to starting the loader. Refer to Informix documentation for
valid operands. If additional loader parameters are forced from within
Product Options, this field cannot be modified. (See the Installation and Configuration
Guide for further information.)
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.
The first grid column contains
a Focus Arrow to indicate the table for which triggers and constraints
are listed. To display the corresponding triggers and constraints
for a different table, click a Focus Arrow grid cell to reposition
the arrow, or use the up/down arrows on your keyboard.
Right-click
in the Status During Process column to select
to enable or disable the corresponding trigger or constraint during
the Load Process. Right-click in 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 select 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.