CREATE Process Table Map

A Table Map is used to specify the names of the tables to be created at the destination. By default, Move assumes the base names of the tables in the Extract File are to be used.

You must specify a Destination Creator ID. This option is required in order to execute the Create Process, grant privileges, specify synonyms and other objects, or use the Output option.

When you select Option 1 Table Map from the CREATE Process menu, the CREATE Process Table Map panel is displayed. Assume the object definitions for three tables are specified in an Extract File. The following panel is displayed:

Figure 1. Create Process Table Map
-------------------------- CREATE Process Table Map ---------------------------
Command ===>                                                  Scroll ===> PAGE 

Available Commands: APPLY,SAVE,LIST,CLEAR, END when Complete 

   Src CID: FOPDEMO 
  Dest CID:                                           >>  

   Extract Tables       Destination Table Name     Type   
--------------------- ------------------------->> ------- 
************************** TOP ************************** 
CUSTOMERS             CUSTOMERS                   UNKNOWN 
ORDERS                ORDERS                      UNKNOWN 
DETAILS               DETAILS                     UNKNOWN 
************************ BOTTOM *************************

Panel

This panel includes:

Src CID
The default Creator ID for the source tables as specified in the Extract File. This value cannot be modified.
Dest CID
The default Creator ID for the destination. Initially, Dest CID is blank. A valid value must be specified.
Extract Tables
Names of the tables included in the Extract File. The Creator ID is included only when it differs from the Src CID. These values cannot be modified.
Destination Table Name
Names of the destination tables that correspond to the listed source tables. Initially, Move supplies the source table names for the destination tables.

You can specify other names by overtyping the name, by requesting a selection list from which to choose, or using the APPLY command. If you leave Destination Table Name blank, the corresponding object definitions in the Extract File are ignored for the current Create Process and the objects are not created.

Type
The destination type supplied by Move and indicated as:
TABLE
A table.
VIEW
A view.
UNKNOWN
Not found or initial display.
A-TABLE
An alias of a table.
A-VIEW
An alias of a view.
S-TABLE
A synonym of a table.
S-VIEW
A synonym of a view.
UNUSED
A destination table is not specified.
TEMPTBL
Temporary table.
LEGACY
A Legacy Table.
S-MQT
System-maintained Materialized Query Table
U-MQT
User-maintained Materialized Query Table

Available Commands

The following commands are available on this panel:
  • APPLY
  • BOTTOM
  • CANCEL
  • DOWN
  • END
  • EXPAND
  • LIST
  • OPTIONS
  • TOP
  • UP

Selection List

TablesThe LIST command is available for aliases, records, synonyms, tables, and views. For example, to obtain a selection list of available tables, use the command LIST TABLES and position the cursor on the destination table name you want to supply and press ENTER. A selection list of available tables with the destination Creator ID is displayed. You can override the destination Creator ID with the LIST TABLES command as in LIST TABLES SMITH.%.

Use the Select line command, S, to select a table name from the selection list. Move automatically places the name in Destination Table Name where the cursor is positioned.

Duplicate table names are not allowed. Therefore, the same table name cannot be specified twice as a destination table.

Use Existing Table Map

You can use the APPLY command to populate the Table Map with the specifications from a previously defined Table Map. If the source tables in the process match the source tables in the Table Map, Move populates the destination tables from the existing Table Map. APPLY can be used to populate all table names and the Dest CID regardless of any entry, or populate only the blank areas.

Destination Table Type

MOVE automatically revises the Type each time you modify a destination table name. If you modify the Dest CID, any tables that are listed without an explicit Creator ID automatically use the new Dest CID. This may cause the Type value to change, requiring your review. You can explicitly supply the Creator ID with the Destination Table Name. If you do this, changing the Dest CID does not affect the table name.

Additional Information

Additional information about defining Table Maps is provided in the Common Elements Manual.

Parent topic: Create Process

Feedback

URL of this topic: