Inserting data

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.