Insert Request Table Specification Dialog

The Insert Request Table Specification dialog enables you to select a specific process option for each table.

Click the Update column to select a process option from the drop down list, for each table. You can also right-click to use shortcut menu commands to set all tables at once.

Insert Request Table Specification dialog
Lock Tables
Select this check box to lock each table until all rows in the Archive or Extract File for that table are processed. Lock tables to ensure that other database activity does not interfere with the process. However, locking prevents other users from accessing tables involved in the process. If a site option prevents you from locking tables, this option is disabled.
Process File Attachments
Select this check box to process file attachments included in the Archive or Extract File. If this option is selected and the Archive or Extract File contains file attachments, each file is restored to a location determined by the Directory Map. The Directory Map dialog is available from the Tools menu or opened automatically when you run the Insert Process.

Use the Directory Map dialog to control the destination for file attachments during Insert Processing. By default, file attachments are returned to the directory from which they were extracted. The Source column identifies the original directory from which file attachments were extracted. The Destination column identifies the directory where files from the corresponding source directory are placed.

You can edit both directories in the Directory Map by entering a path or using the browse button. All source entries must be unique. If the specified source directory does not match the original path or the source is blank, the Default Path is used for the insert. If the Default Path is not found, the Insert Process will attempt to insert the file into the original path. If no matching paths are found, the Insert Process will stop before inserting any data.

Directory Map dialog

Several shortcut menu commands are available. Select Remove to remove one row of source and destination entries, or select Remove All to remove all entries. Select Clear Column to remove all entries for the source or destination. Use Add Entries from File to add the original paths found in the Archive or Extract File.

Commit Frequency
Enter the number of rows to process before committing the changes to the database, up to a maximum of 999999. Clear this box to use the number specified as the Maximum Commit Frequency in Product Options. This option is disabled if Lock Tables is selected.

Frequent commits keeps locking to a minimum, but may slow the process. If the process ends abnormally, click Utilities > Restart/Retry to resume processing from the last commit point. See the Common Elements Manual for further information.

Discard Row Limit
Enter 0 or leave blank to impose no limit or enter a number from 1 to 999999999 to stop processing after the specified number of rows are discarded and all rows in the array processed. You can Restart or Retry a process that stops because the limit is reached.
Discard Row Limit is an approximate value due to array processing. For example, assume the discard limit is set to 50 and the array supports 200 rows for a given table. If the first 50 rows fail, the DBMS continues to process the remaining 150 rows in the array, before evaluating the discard limit. (The number of rows that can be inserted via one call to the DBMS depends on the size of the row.)

Disable Triggers

The following options are supported for disabling triggers for Oracle, Informix®, SQL Server (Version 7 or later), and Sybase ASE (Version 12 or later).

Always
Select this option to disable all database triggers for the Insert Process, re-enabling the triggers after the process completes.
Never
Select this option to execute all database triggers during the Insert Process.
Prompt
Select this option to selectively disable database triggers during the Insert Process and selectively re-enable triggers when the process is complete.

Disable Constraints

The following options are supported for disabling constraints for Oracle, Informix, and SQL Server (Version 7 or later)

Always
Select this option to disable constraints during the Insert Process and re-enable the constraints after the process completes.
Never
Select this option if you do not want to disable referential integrity constraints. When this option is selected, a warning message displays to remind you when you run the Insert Request.
Prompt
Select this option to display the Disabling Trigger/Constraint Confirmation dialog. The dialog displays a list of tables for each applicable DB Alias and the corresponding triggers and constraints. You can right‑click to enable or disable constraints during the Insert Process for each table. You can also enable or disable the constraints after the Insert Process completes.

The Disabling Trigger/Constraint Confirmation dialog displays the list of tables in the Insert Process from each specified database and tabs that contain the corresponding database triggers and referential integrity constraints for each table.

Disabling Trigger/Constraint Confirmation dialog

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 Insert Process. Right-click in the Status After Process column to select whether to enable or disable the trigger or constraint after the Insert 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.)

Always Call Create

Select this check box to start the Create Utility before the Insert Process begins, to allow you to create or drop objects in the destination database. Clear this check box to start the Create Utility only when necessary to create desired objects in the destination database.