DB Alias Tab – Informix, Load Request Editor

Use the DB Alias tab to define the specific parameters needed to perform the Load Process for the Informix® loader.

Load Request Editor with DB Alias - Informix as the active tab. The elements of the DB Alias - Informix tab are described as follows.

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 Tools > Edit Exception Table Map 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.

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.

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.

Disabling Trigger/Constraint Confirmation dialog

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.