Field-Mapping Editor

The Field-Mapping Editor is used to specify a field-to-field mapping of two templates. The information specified in this editor is used when invoking File ManagerĀ® utility functions that involve the manipulation of fields while executing (e.g. the Copy and Compare utility functions). The mapping information is always stored in the To template (the other template being the From template). The user can specify Base and DB2 templates.

Field-Mapping Editor (with Base templates)
Field-mapping editor with Base templates image
Field-Mapping Editor (with DB2 templates)
Field-mapping editor with DB2 templates image

The field-mapping editor can be started in one of the following ways:

  1. By invoking Template Field-Mapping action from the context menu in the Systems Information view
  2. By clicking the Mapping button in the template editor.

When the editor is invoked from the Systems Information view, the first selection is used as the To template. If two templates were selected, then the second selection is used as the From template. When the editor is invoked by clicking on the Mapping button in the Template Editor, then the currently edited template is used as the To template.

When the editor is opened, the To template is always pre-filled based on the selection. By default, the same template is specified for the From template unless two templates were selected when the editor was invoked from the Systems Information view. The From template can always be changed by either typing in the From template name, or looking it up by clicking on the Lookup button lookup button image.

Once the editor is up and both the To template and From template are specified, start the field-mapping session by clicking on the Load button load mapping image. If field-mapping information was specified before, then the saved mapping information is loaded into the editor. Otherwise, the default mapping is generated by File Manager. To re-set the field-mapping information, click the Generate the default field mapping button mapping regenerate button image. When the Map button is clicked, the Field Selection dialog appears which allows a field to be selected in the From template.

Field selection dialog (with Base templates)
Field selection dialog with Base templates image
Field selection dialog (with Base templates)
Field selection dialog with DB2 templates image

Once the field-mapping information is loaded, fields are displayed side-by-side which represents how a field in the To template is mapped to a field in the From template. Field-mappings can be changed by selecting a field in the To template and selecting either the Map button map field button image or the Unmap button unmap field button image. Attributes for a field can also be specified by clicking the Attributes button attributes button image.

The field-mapping information is always stored in the To template. When the OK button is clicked, the specified mapping information is validated and saved in the To template. If any error occurs, a dialog is displayed with the description of the error discovered during the validation.