Inserting archived data

Use an insert process to insert data from an archive file or extract file into a destination database.

If the file contains data from tables that do not exist at the destination, the insert process uses object definitions in the file to create the tables. Specifications for the insert process are embodied in an insert request, which may be named and saved in the Optim™ directory, so that it is available for a variety of users and uses. An insert request may also be embedded in a restore request, in which case it is not named and is not accessible except by editing or using the restore request. Based on your specifications, you can:

Mapping and transformation

You must use a table map to identify the destination tables for data in the archive or extract File. You may also use column maps to control or transform the data inserted in destination columns.

Load versus insert

Archive can move data into a database by using an insert process or a load process. Consider the following items when deciding the best method:

Run online or automate

You can process an insert request immediately (by clicking File > Run). You can also run an Insert Request from the command line, whether manually, in batch, or from an external application. When running a process from the command line, you can supply overrides for various insert request parameters and settings to tailor the process to circumstances as they exist at runtime. (See Command Line Interface — Processing Utilities for more information.) Named insert requests can also be scheduled for automated processing by clicking File > Schedule.