Open the Create Utility

In the main window, select Create from the Utilities menu to display the Create Options dialog.

create options dialog where you can specify a source file containing object definitions to create

Server Name

If the optional Optim Server is available on your network, you can click the down arrow and select the Server on which the file resides, or Local (to access the source file on the workstation).

Source File

The name of the source Extract or Archive File containing the database object definitions to create.

Note: If you select the name of an Archive File stored on tape or Centera from the drop-down list, the file is recalled to the Alternate File Path specified in the Storage Profile.

Table Map Options

Local
Use a temporary Table Map, retained for the current Create Process only. A local Table Map is discarded when you close the Create dialog.
Named
Use a Table Map saved in the Optim™ Directory. You must provide a Table Map name.
Table Map Name
The name of a new or existing Table Map to be used for the Create Process. Click the down arrow to select from a list of recently referenced Table Maps, or click the browse button to open a dialog where you can select a Table Map.
Always View Table Map
Option to review or modify the Table Map specifications before you create the objects. Select this check box to review the Table Map each time you open the Create Utility.

If you clear this check box, the Table Map Editor opens automatically if you specify a local Table Map or a named Table Map that does not exist or that does not reference all tables in the Extract or Archive File.

Using Table Maps

A Table Map matches source tables with tables to be created at the destination (i.e., the target). You can exclude tables from processing or create objects with names different from those of source objects.

Edit a Table Map

If needed, you can edit the Table Map. For example, if changes to database tables and other database objects have occurred since the Table Map was last used, the Table Map specifications may not be valid.

If the Table Map Editor is not displayed automatically, select Edit Table Map from the Tools menu on the Create dialog to open the Table Map Editor. For details on how to create, edit, or merge Table Maps, see Open the Table Map Editor.

After reviewing or modifying the Table Map, select Update and Return from the File menu to redisplay the Create dialog.