After the referentially intact set of data is extracted
and stored in the Extract File, use the Extract File as the source
to insert data using the Insert Process. The parameters for the Insert
Process are specified in an Insert Request.
In this scenario, you will create a test database
using an Insert Request and populate the database with the data in
the Extract File.
Note: If you are not authorized to create new tables, you may be unable
to continue this scenario. Check with the site management for the
destination tables to use.
To begin the Insert Process, click from the main window to display the Insert
Request Editor.
Use the Insert Request Editor to
create and edit requests for inserting data into a database. You can
enter a Description to indicate the purpose
or function of the Insert Request.
If the optional Optim™ Server
component is installed, you can use the Server Name box
to select a server on which to process the request, or select Local to
process the request locally. For this scenario, select Local,
which is the default.
Use the General tab to specify
parameters for the Insert Process. The other tabs are not used.
- Source File
- Enter the name of the Extract File that contains
the data to insert.
For this scenario, click the
Last Extract button
to select the last Extract File created. If the Scenario
1 Extract File was not the last Extract File created, use the Browse
button
to
locate the file.
- Control File
- Enter the name of a Control File. A Control File
is generated during the Insert Process to track the success or failure
of each row in the Extract File. Control Files have a .cf extension
by default.
- Table Map Options
- A Table Map directs the placement of data in the
Insert Process by identifying and matching tables in the source, or
Extract File, with those in the database. In addition, you can use
a Table Map to exclude tables from processing.
Table
Map Options allow you to use a named Table Map that is saved and can
be used with other process requests, or a Local Table Map that is
saved as part of the Insert Request.
For this
scenario, select Local to create a Local Table
Map.
- Always View Table Map
- Use this option to open the Table Map
Editor each time you run the Insert Request. This option
provides an opportunity to review the Table Map specifications before
you insert data.
For this scenario, do not select
this option.
- Delete Options
- Delete Options let you delete rows from all or specified
destination tables or retain all rows in destination tables (no delete).
For this scenario, use the default setting No
Tables to retain rows already in the database.
- Process Options
- Process Options allow you to select the type of
Insert Processing to be performed and specify parameters to be used.
You can insert new rows only; insert new rows and update existing
rows; or update existing rows only. You can apply these options globally
or on a table-by-table basis.
For this scenario,
select Insert to insert new rows of data into
the specified tables.
- Process File Attachments
- Select this check box to insert file attachments
specified in the Access Definition.
- Lock Tables
- Select this check box to lock database tables (if
authorized) to ensure that other database activity does not interfere
during processing.
For this scenario, do not select
this option. Lock Tables is not applicable to this scenario because
the tables you create for the test database are new.
- Commit Frequency
- Specify the number of rows to process before committing
the changes to the database.
For this scenario, use
the default Commit Frequency established by the system administrator.
(See the Installation and Configuration
Guide.)
- Discard Row Limit
- Specify the maximum number of rows that can be discarded.
When the specified limit is reached and all rows in the array have
been processed, the Insert Process is cancelled.
For
this scenario, use the default setting of 0 to allow an unlimited
number of discarded rows.
- Disable Triggers
- Specify options to disable database triggers during
the Insert Process.
For this scenario, use the default
setting. For complete information about disabling triggers in an Insert
Request, see Disable Triggers.
- Disable Constraints
- Specify options for disabling referential integrity
constraints.
For this scenario, use the default setting.
For complete information about disabling constraints in an Insert
Request, see Disable Constraints.
- Always Call Create
- Select this option to always start the Create Utility
to create or drop objects in the destination database before inserting
the data. If you do not select the option, the Create Utility starts
only when necessary to create desired objects in the destination database.
For this scenario, do not select this option.
Note: The
Age Function and
Global
Aging tabs are used to age data. The
Report
Options tab enables you to customize the process report,
and the
Currency tab is used to specify default
currency conversion factors. For this scenario, the data is not aged,
the report is not customized, and currency is not converted, therefore
these tabs are not used. See
Using the Insert Request Editor for
detailed information about Insert Requests.