Create

Use the Create Utility to create objects that are based on 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, which you can edit before it is executed, and displays information that is 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 exist.

Contents

This section explains how to use the Create Utility, including how to
  • Specify options for the Create Process.
  • Review a Table Map to map the source definitions to the destination.
  • Browse and review the SQL.
  • Create and drop objects.


Feedback