Create

Use the Create Utility to create objects on the basis of definitions in a source Extract or Archive File.

For example, if authorized, you can use the utility to create:

Using the Create Utility, you identify the destination and select objects from the source file to be created or dropped at the destination. The Create Utility then generates the necessary SQL, lets you edit the SQL before it is executed, and displays information returned from the DBMS after execution.

From the Main Window

To create objects at a destination without loading data, open the Create Utility from the main window.

During a Process

To create the objects and load data, use an Insert, Restore, or Load Process, as appropriate. If destination tables and other objects (such as primary keys and relationships) do not exist in the destination, you are prompted during the process to create them. These processes do not automatically create objects for destination tables or objects that already exist.

Contents

This section explains how to use the Create Utility, including how to: