Message Flow Mapping editor

This is the default editor provided by the Broker Application Development perspective for defining mappings between elements in message files, and columns in database tables. Using a drag-and-drop method, you can create field to field, structure to structure, repeating field, and repeating structure mappings. You can also call user-defined ESQL subroutines in maps.

The editor is launched when you select the Open Mappings command on a Mapping node, DataDelete node, DataUpdate node, DataInsert node, Warehouse node, or an Extract node.

Message Flow Mapping editor views

The Message Flow Mapping editor has the following views:

Outline view
Provides a convenient view of existing mappings. You cannot edit a mapping assignment in this view, but you can launch a Compose Expression editor to help you with this task.
Overview view
This is where you order mapping entries by source or target fields.
Properties view
This is where you view and edit mappings.

Message Flow Mapping editor toolbar

The icons in this editor and their actions are shown in the table below.

Icon Label Action

Select next mapped object
Select next mapped object Selects the next mapped object in the source or target view.

Select previous mapped object
Select previous mapped object Selects the previous mapped object in the source or target view.

Select next unmapped object
Select next unmapped object Selects the next unmapped object in the source or target view.

Select previous unmapped object
Select previous unmapped object Selects the previous unmapped object in the source or target view.

Show only maped objects
Show only mapped objects Displays only the mapped objects in the source or target view.

Select corresponding mapped objects in other view

Select corresponding mapped object in other view
Select corresponding mapped objects in other view When clicked in one view (source or target), this button selects the corresponding mapped object in the other view.

Exchange source and target
Exchange source and target Displays source in the first column of the Overview view.

Show each root in its own column
Show each root in its own column Displays each root in its own column in the Overview view.

Show both mapped and unmapped objects
Show both mapped and unmapped objects Displays both mapped and unmapped objects in the Overview view.

Related concepts
Mappings
Compose Expression editors

Related reference
Broker Application Development perspective