Optim™ can insert
data into a database in two ways — using a load process or an insert
process.
Consider the following when deciding which method to use:
- The volume of data and the speed of using the database
load utility may offset the advantages of the insert process.
- The data may contain referential integrity (RI)
cycles that exceed the capability of the insert process to insert
all the data successfully.
- The database load utility requires exclusive control
of the database and prevents user access during the load process.
The database is available to other users while the insert process
is performed.
- The database load utility either inserts new data
or replaces existing data. The insert process allows for update/insert
processing in one step.