Create an Insert Request

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 File > New > Insert from the main window to display the Insert Request Editor.

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.