Using the Editor

In the Table Map Editor, you can create, modify, or delete Table Maps stored in the Optim™ Directory or defined within an Action Request.

You can edit a Table Map in any or all of the following ways:

When you create a new Table Map, the source and destination table grid cells in the Table Map Editor are populated automatically, according to options selected on the New Table Map dialog (see Create a Table Map). You can edit the destination table names and you can create or specify Column Maps, as needed.

Source or Source 1

Qualifier provides the default DB Alias and Creator ID for source tables in the Extract or Archive File or referenced in the Access Definition that are not fully qualified.

Destination or Source 2

Enter the default qualifier (dbalias.creatorid) for the destination table(s) listed in the Table Map. Click the down arrow or the browse button to select from a list.

Note:
  • You must specify a valid default qualifier before you can save the Table Map.
  • If you select 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.

Description

Text to describe or explain the purpose of the Table Map (up to 40 characters).

Column Map ID

The Column Map Identifier qualifies any Column Maps specified by the base name only. If you specify a fully qualified Column Map name in the Column Map or “LOCAL” grid column, the Column Map ID is ignored. When you create a new Table Map, the Column Map ID is initially blank.

Server Name

Location of the Extract File containing the source tables, if applicable, is displayed.

Tabs

Tabs on the Table Map Editor correspond to the types of objects in the Extract or Archive File or referenced in the Access Definition. If an object type is not in the source, the tab is hidden. Only the Tables tab is enabled when Compare validation rules are used.

Use Default Values for Unused Objects

The effect of this option depends upon the method used to open the Table Map Editor:

Tools Menu Commands

In addition to the standard commands on the File, Edit, and Tools menus, you can select the following commands from the Tools menu:

Convert to Local
When referencing a named Table Map in an action request, select this command to save the Table Map within the action request.
Merge...
Open the Merge Table Map dialog to allow you to select a Table Map to overlay all or part of the active Table Map.
Populate...
Open the Populate Column Map dialog to allow you to specify criteria for selecting a Column Map for each pair of tables in the Table Map. If the Populate routine finds more than one Column Map that meets your criteria, you can select from a list of possible matches.
Populate
Populate Destination or Source 2 object names, as follows:
  • Select Add to insert the source object names in any blank destinations.
  • Select Clear to remove all destination object names and insert the source object names.
  • Select Empty to remove all destination object names and leave each cell blank.
  • Select Copy This Entry to copy the source object name to the current destination object name.
Default All Archive Actions
Reset Archive Actions for all tables to the Access Definition defaults. You can also right-click the table list and select this command from the shortcut menu. See Create or Modify Archive Actions in a Table Map.

Tables Tab

Select the Tables tab to review mapped database tables or views. The source must be a table, but the destination can be a table or a view.

Source Table or Source 1 Table
List of source table names. You cannot modify these values.
Destination Table or Source 2 Table
List of destination tables. When you create a new Table Map, the destination names are initially the same as those listed for the source. You can modify these values.
Type
Type of object named in Destination Table or Source 2 Table:
Table
Destination table is valid.
View
Destination view is valid.
Unknown
Destination table or view does not exist or is not recognized.
Unused
Destination table or view is not specified.
A-Table
Destination is an alias of a table.
A-View
Destination is an alias of a view.
View Error
View is invalid and not usable.
Pending
A default qualifier is needed for the destination. To avoid validation errors, specify a valid destination default qualifier for the mapped tables.
Inaccessible
DB Alias cannot be accessed.
Incomplete
Destination table or view name is not fully qualified. You must specify:
  • A valid Default Qualifier under Destination or Source 2, or
  • A fully qualified name in the Destination Table or Source 2 Table grid column.
Column Map or “LOCAL”
Name of the Column Map for a specific pair of tables in the Table Map:
  • If you specify unqualified Column Map names, you must specify a Column Map ID.
  • If you specify LOCAL, the Column Map is saved with the Table Map and is available only to that Table Map.

For information on referencing Column Maps in a Table Map, see Specify Column Maps in a Table Map.

Column Map Status
Status of the Column Maps referenced in the Table Map. This status is provided automatically:
Defined
Column Map exists.
Incomplete
Fully qualified name of the Column Map or the Column Map ID must be specified.
Unknown
Column Map does not exist.
Unused
Column Map is not used.

Defaults Tab

Select the Defaults tab to review mapped source and destination defaults.

Source Default
List of source defaults. You cannot modify these values.
Destination Default
List of destination defaults. When you create a new Table Map, these names are initially the same as those listed for the source. You can modify these values.
Status
Automatically provides information about the destination default:
Defined
Default exists in the destination database.
Inaccessible
Destination database cannot be accessed.
Incomplete
Destination default is not fully qualified. Specify a valid destination qualifier, or specify a fully qualified default name.
Pending
When creating a new Table Map, the destination defaults are initially listed, but you must specify a valid destination Qualifier.
Unknown
Destination default does not exist.
Unsupported
Defaults not supported in the database.
Unused
Destination default is not specified.

Functions Tab

Select the Functions tab to review mapped source and destination database functions.

Source Function
List of source functions. You cannot modify these values.
Destination Function
List of destination functions. When you create a new Table Map, these names are initially the same as those listed for the source. You can modify these values.
Status
Automatically provides information about the destination function:
Defined
Function exists in the destination database.
Inaccessible
Destination database cannot be accessed.
Incomplete
Destination function is not fully qualified. Specify a valid destination qualifier, or specify a fully qualified function name.
Pending
When creating a new Table Map, the destination functions are initially listed, but you must specify a valid destination Qualifier.
Unknown
Destination function does not exist.
Unsupported
Functions not supported in the database.
Unused
Destination function is not specified.

Packages Tab

Select the Packages tab to review mapped source and destination database packages.

Source Package
List of source packages. You cannot modify these values.
Destination Package
List of destination packages. When you create a new Table Map, these names are initially the same as those listed for the source. You can modify these values.
Status
Automatically provides information about the destination package:
Defined
Package exists in the destination database.
Inaccessible
Destination database cannot be accessed.
Incomplete
Destination package is not fully qualified. Specify a valid destination qualifier, or specify a fully qualified package name.
Pending
When creating a new Table Map, the destination packages are initially listed, but you must specify a valid destination qualifier.
Unknown
Destination package does not exist.
Unsupported
Packages not supported in the database.
Unused
Destination package is not specified.

Procedures Tab

Select the Procedures tab to review mapped source and destination database procedures.

Source Procedure
List of source procedures. You cannot modify these values.
Destination Procedure
List of destination procedures. When you create a new Table Map, these names are initially the same as those listed for the source. You can modify these values.
Status
Automatically provides information about the destination procedure:
Defined
Procedure exists in the destination database.
Inaccessible
Destination database cannot be accessed.
Incomplete
Destination procedure is not fully qualified. Specify a valid destination qualifier, or specify a fully qualified procedure name.
Pending
When creating a new Table Map, the destination procedures are initially listed, but you must specify a valid destination qualifier.
Unknown
Destination procedure does not exist.
Unsupported
Procedures not supported in the database.
Unused
Destination procedure is not specified.

Rules Tab

Select the Rules tab to review mapped source and destination rules.

Source Rule
List of source rules. You cannot modify these values.
Destination Rule
List of destination rules. When you create a new Table Map, these names are initially the same as those listed for the source. You can modify these values.
Status
Automatically provides information about the destination rule:
Defined
Rule exists in the destination database.
Inaccessible
Destination database cannot be accessed.
Incomplete
Destination rule is not fully qualified. Specify a valid destination qualifier, or specify a fully qualified rule name.
Pending
When creating a new Table Map, the destination rules are initially listed, but you must specify a valid destination Qualifier.
Unknown
Destination rule does not exist.
Unsupported
Rules not supported in the database.
Unused
Destination rule is not specified.

Sequences Tab

Select the Sequences tab to review mapped source and destination sequences.

Source Sequence
List of source sequences. You cannot modify these values.
Destination Sequence
List of destination sequences. When you create a new Table Map, these names are initially the same as those listed for the source. You can modify these values.
Status
Automatically provides information about the destination sequence:
Defined
Sequence exists in the destination database.
Inaccessible
Destination database cannot be accessed.
Incomplete
Destination sequence is not fully qualified. Specify a valid destination qualifier, or specify a fully qualified sequence name.
Pending
When creating a new Table Map, the destination sequences are initially listed, but you must specify a valid destination qualifier.
Unknown
Destination sequence does not exist.
Unsupported
Defaults not supported in the database.
Unused
Destination sequence is not specified.

User Defined Types Tab

Select the User Defined Types tab to review mapped source and destination user defined types (UDTs).

Source UDT
List of source UDTs. You cannot modify these values.
Destination Rule
List of destination UDTs. When you create a new Table Map, these names are initially the same as those listed for the source. You can modify these values.
Status
Automatically provides information about the destination UDT:
Defined
UDT exists in the destination database.
Inaccessible
Destination database cannot be accessed.
Incomplete
Destination UDT is not fully qualified. Specify a valid destination qualifier, or specify a fully qualified UDT name.
Pending
When creating a new Table Map, the destination UDTs are initially listed, but you must specify a valid destination Qualifier.
Unknown
Destination UDT does not exist.
Unsupported
UDTs not supported in the database.
Unused
Destination UDT is not specified.

Views Tab

Select the Views tab to review mapped source and destination database views. The source and the destination must be a view. (Note that on the Tables tab, the source must be a table, and the destination can be a table or a view.)

Source View
List of source views. You cannot modify these values.
Destination View
List of destination views. When you create a new Table Map, these names are initially the same as those listed for the source. You can modify these values.
Status
Automatically provides information about the destination view:
Defined
View exists in the destination database.
Inaccessible
Destination database cannot be accessed.
Incomplete
Destination view is not fully qualified. Specify a valid destination qualifier, or specify a fully qualified view name.
Pending
When creating a new Table Map, the destination views are initially listed, but you must specify a valid destination qualifier.
Unknown
Destination view does not exist.
Unsupported
Views not supported in the database.
Unused
Destination view is not specified.

Assemblies Tab

Select the Assemblies tab to review mapped source and destination database assemblies.

Source Assemblies
List of source assemblies. You cannot modify these values.
Destination Assemblies
List of destination assemblies. When you create a new Table Map, these names are initially the same as those listed for the source. You can modify these values.
Status
Automatically provides information about the destination assemblies:
Defined
Assembly exists in the destination database.
Inaccessible
Destination database cannot be accessed.
Incomplete
Destination assembly is not fully qualified. Specify a valid destination qualifier, or specify a fully qualified view name.
Pending
When creating a new Table Map, the destination assemblies are initially listed, but you must specify a valid destination qualifier.
Unknown
Destination assembly does not exist.
Unsupported
Assemblies not supported in the database.
Unused
Destination assembly is not specified.

Partition Functions Tab

Select the Partition Functions tab to review mapped source and destination database partition functions.

Source Partition Functions
List of source partition functions. You cannot modify these values.
Destination Partition Functions
List of destination partition functions. When you create a new Table Map, these names are initially the same as those listed for the source. You can modify these values.
Status
Automatically provides information about the destination partition functions:
Defined
Partition function exists in the destination database.
Inaccessible
Destination database cannot be accessed.
Incomplete
Destination partition function is not fully qualified. Specify a valid destination qualifier, or specify a fully qualified view name.
Pending
When creating a new Table Map, the destination partition functions are initially listed, but you must specify a valid destination qualifier.
Unknown
Partition function does not exist.
Unsupported
Partition functions not supported in the database.
Unused
Partition function is not specified.

Partition Schemes Tab

Select the Partition Schemes tab to review mapped source and destination database partition schemes.

Source Partition Schemes
List of source partition schemes. You cannot modify these values.
Destination Partition Schemes
List of destination partition schemes. When you create a new Table Map, these names are initially the same as those listed for the source. You can modify these values.
Status
Automatically provides information about the destination partition schemes:
Defined
Partition scheme exists in the destination database.
Inaccessible
Destination database cannot be accessed.
Incomplete
Destination partition scheme is not fully qualified. Specify a valid destination qualifier, or specify a fully qualified view name.
Pending
When creating a new Table Map, the destination partition schemes are initially listed, but you must specify a valid destination qualifier.
Unknown
Partition scheme does not exist.
Unsupported
Partition schemes not supported in the database.
Unused
Partition scheme is not specified.