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