WebSphere Message Broker, Version 8.0.0.7
Operating Systems: AIX, HP-Itanium, Linux, Solaris, Windows, z/OS
See information about the latest product version
See information about the latest product version
Transform types in the Graphical Data Mapping editor
In the Graphical Data Mapping editor, you can map elements and attributes between the input and output objects, and then apply a transform to the mapping that specifies the action to be performed on the input data. The result of the transform is stored in the output element.
The following table shows the standard mapping transforms that are provided by the Graphical Data Mapping editor:
Transform | Description |
---|---|
Assign | Sets a value in the output element. There is no input element. Column values set via Assign transform will always be passed as character string. |
Cast | Sets a specific value type in the output element. Cast can also move and convert an input element to become a specific value type in the output element. |
Concat | Creates a string concatenation that allows you to retrieve data from two or more entities and link them into a single result. |
Convert | Copies the input element to the output element and changes the type. The transform takes a single simple input and creates a single simple output with a different type. |
Create | Creates an empty element, a nil element, or a simple type element using a default value based on the element's type. |
Custom ESQL | Enables you to enter your own ESQL code to be used in the transform. |
Custom Java | Enables you to enter your own Java code to be used in the transform. |
Custom XPath | Enables you to enter your own XPath expressions to be used in the transform.. |
Move | Copies data from the input element to the output element. |
Normalize | Normalizes the input string by removing white space such as spaces, tabs, and returns, and moves the resulting normalized string to the output element. |
Substring | Extracts information as required, and moves the extracted string to the output element. |
Task | Describes a manual task or point of concern that might need to be reviewed or resolved before a graphical data map can be used in your messaging solution. |
XPath | All XPath 2.0 functions are supported, in the form fn:<function_name>. |
The following table shows the database transforms that are provided by the Graphical Data Mapping editor:
Transform | Description |
---|---|
Delete | Deletes one or more rows in a database table matched by a Where clause. |
Failure | Enables the map to take-on error handling for any exceptions raised by the database server in a database transform, instead of having such exceptions stop the map and be reported. |
Insert | Inserts a row into a database table. |
Return | Enables additional processing after a successful Insert, Update, or Delete database operation, or Database Routine call. Provides the results from the database operation or call as inputs. |
Select | Retrieves data from rows in a database table, so that the data can be used as input in a graphical data map. |
Update | Updates one or more rows in a database table matched by a Where clause with a single set of data values. |
In addition to the mapping transforms described in the previous
tables, several structural transforms are provided. The structural
transforms control how nested elements are displayed in the Graphical
Data Mapping editor, but they have no effect on the data itself. The
structural transforms are described in the following table:
Transform | Description |
---|---|
Append | Appends occurrences of an output array in the order of the inputs. |
ForEach | Iterates over an input array element (either a simple type or a complex type). |
If, Else if, and Else | Enables you to control the flow of the mapping by setting conditions. |
Join | Joins elements from two or more inputs. |
Local map | Provides a hierarchical view of element transforms in the graphical data map. |
Submap | References another map. It calls a map from this or another map file, which can be stored in a library, an application, or a Message Broker project. |