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:
- Specify Destination or Source 2 table names or select from a list.
- Merge Table Maps to include tables, Column Maps, or both.
- Include Column Maps in a Table Map manually, select
from a list, or specify Column Maps automatically.
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:
- If you open the Table Map Editor from a process request, select this option to update the Table Map to include all unused Extract or Archive File objects in the Table Map. The Table Map is updated by the process request.
- If you open the Table Map Editor from the main window, select this option to include unused objects automatically whenever the Table Map is specified in a process request.
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 Actions
- Reset 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 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.