Rational Developer for System z

Descriptions of the transforms and their mappings

A transform is a configurable operation that can be associated with source elements and target elements to create a mapping.
This topic contains the following subtopics:
"Numeric": Numeric is not a data type but rather a descriptive category that includes the following actual types:
  • decimal
  • double
  • float
  • int, integer
  • long
Using array elements: To refer to an array element use the array name followed by the index of the element in square brackets []. The index value must resolve to an integer. The first element of an array has the index 1 (example: MyArray[1]).

Transforms that create one-sided mappings

A one-sided mapping stores literal data into a target message (see Types of mappings).

The following transforms do one-sided mapping:

Table 1. Transforms that create one-sided mappings
Transform: Description:
Assign Assigns a literal value to a target message. The literal value and the target element must have the same type.1
Clear Sets the target element to spaces. The target element must be a string.
Current Date, Current Time, Current Timestamp Sets the target element to the current date, the current time, or the current date and time. The target element must be a string.
Custom Mapping Provides the user with the ability to specify complex mapping statements expressed in ESQL.
1 Specifying text for an Assign transform: The Value field on the General tab of the Assign transform expects normal text not an ESQL expression. Therefore do not surround text in this field with single quotes unless you want the single quotes to be part of the string (see Assign transform). For example, to use the Assign transform to store the string JOE into a variable enter JOE not 'JOE'.

Transforms that create one-to-one mappings

A one-to-one mapping reads data from a single source element and stores a result into a single target element (see Types of mappings).

The following transforms do one-to-one mappings:

Table 2. Transforms that create one-to-one mappings
Transform: Description:
ACOS, ASIN, ATAN, COS, SIN, TAN Returns the value of a trigonometric function. Both the source element and the target element must be numeric.
Cast Casts the source element to the type of the target element.
Custom Mapping Provides the user with the ability to specify complex mapping statements expressed in ESQL.
Length Returns the length of the source element. The source element must be a string and the target element must be numeric.
LOG, LOG10 Returns the natural logarithm or the 10-based logarithim of the source element. Both the source element and the target element must be numeric.
Lower Case Returns the value of the source element in lower case. Both the source and target elements must be strings.
Move Moves the value of the source element to the target element. Both the source and target elements must have the same type
Overlay Returns a string overlaid with another string at a location indicated by offset and length parameters. Both the source and target elements must be strings.
Substring Substring – Returns the portion of the source element indicated by offset and length parameters. Both the source and target elements must be strings.
Upper Case Returns the value of the source element in upper case. Both the source and target elements must be strings.

Transforms that create many-to-one mappings

A many-to-one mapping reads data from multiple source elements and stores a result into a single target element (see Types of mappings).

The following transforms do many-to-one mappings:

Table 3. Transforms that create many-to-one mappings
Transform: Description:
Add Adds the second source element to the first source element. The two source elements and the target element must be strings.
Concatenate Concatenates the second source element to the first source element. The two source elements and the target element must be numeric.
Custom Mapping Provides the user with the ability to specify complex mapping statements expressed in ESQL.
Divide Divides the first source element by the second source element. The two source elements and the target element must be numeric.
Multiply Multiplies the first source element by the second source element. The two source elements and the target element must be numeric.
Subtract Divides the second source element by the first source element. The two source elements and the target element must be numeric.

Transforms that create group mappings

A group mapping is a mapping in which the source element and the target element are groups (see Types of mappings).

The following transforms do group mappings:

Table 4. Transforms that create group mappings
Transform: Description:
Custom Mapping Provides the user with the ability to specify complex mapping statements expressed in ESQL.
Move Moves the value of the source group to the target group. Both the source and target groups must have the same structure.


Terms of use | Feedback

This information center is powered by Eclipse technology. (http://www.eclipse.org)