C
Transformations

This appendix provides a list of the Oracle9iAS InterConnect transformations.

Copy Fields

Copy the source field(s) into the destination field(s).

Parameters:

None

Copy Object

Copy the source object into the destination object.

Parameters:

None

Concat Fields

Concatenate the source field(s) and copy into the destination fields.

Parameters:

prefix	An optional prefix to the concatenated string.
separator	The separator, a string of characters, that separate source fields in the concatenated string.
suffix	An optional suffix to the concatenated string.

Expand Fields

Expand the source field into the destination fields.

Parameters:

delimiter

The delimiter or string of characters around which the source field should be broken up.

Set Constant

Copy a constant into the destination fields.

Parameters:

constant

The constant to be copied.

True Conditional Lookup XRef

Finds the source field in a cross reference table. If condition is satisfied, copy it into the destination field.

Parameters:

condition	The condition for this parameter.
table	The cross reference table.
pass through	When there is no corresponding cross reference, and this parameter is `true`, the destination field is set to the source field. If this parameter is `false`, the destination field is set to null.

True Conditional Lookup DVM

Finds the source field in a domain value map table. If condition is satisfied, copy it into the destination field.

Parameters:

condition	The condition for this parameter.
table	The domain value map table.
pass through	When there is no corresponding domain value map and this parameter is set to `true`, the destination field is set to the source field. If this parameter is set to `false`, the destinations field is set to null.

Conditional Copy

Copy the source field(s) into the destination field(s) if expression is satisfied.

Parameters:

expression	The expression.
only copy on true	If this parameter is set to `true` and the expression evaluates to `false`, nothing is copied. If this parameter is set to `false` and the expression evaluates to `false`, the second input object is copied.

True Conditional Copy

Copy the source field(s) into the destination field(s) if condition is satisfied.

Parameters:

condition

The condition for this parameter.

True Conditional Concat

Concatenate the source field(s) into the destination field if the condition is satisfied.

Parameters:

condition	The condition for this parameter.
prefix	An optional prefix to the concatenated string.
separator	The separator, a string of characters, that separate source fields in the concatenated string.
suffix	An optional suffix to the concatenated string.

True Conditional To Number

Convert the sign, value, and precision source fields into a number and copy it into the destination field if condition is satisfied.

Parameters:

condition	The condition for this parameter.
int length	The number of digits before the decimal point excluding the sign.
dec length	The number of digits after the decimal point.
character	The padding character.
DVM	An optional domain value map to lookup decimal point character.

False Conditional Copy

Copy the source field(s) into the destination field(s) if condition is NOT satisfied.

Parameters:

condition

The condition for this parameter.

False Conditional Concat

Concatenate the source field(s) into the destination field if the condition is NOT satisfied.

Parameters:

condition	The condition for this parameter.
prefix	An optional prefix to the concatenated string.
separator	The separator, a string of characters, that separate source fields in the concatenated string.
suffix	An optional suffix to the concatenated string.

False Conditional To Number

Convert the sign, value, and precision source fields into a number and copy it into the destination field if condition is NOT satisfied.

Parameters:

condition	The condition for this parameter.
int length	The number of digits before the decimal point excluding the sign.
dec length	The number of digits after the decimal point.
character	The padding character.
DVM	An optional domain value map to look up a decimal point character.

To Number

Convert the sign, value, and precision source fields into a number and copy it into the destination field.

Parameters:

int length	The number of digits before the decimal point excluding the sign.
dec length	The number of digits after the decimal point.
character	The padding character.
DVM	An optional domain value map to look up a decimal point character.

Substring

Copy a substring of the source field into the destination field.

Parameters:

begin index	The index at which the substring begins.
length	An optional length of the substring.

Char Replace

Replace characters in the source field and copy it into the destination field.

Parameters:

targets	The string of characters to replace.
replacements	The string of replacement characters.

String Replace

Replace each occurrence of a string in the source field and copy it into the destination field.

Parameters:

targets	The string of characters to replace.
replacements	The string of replacement characters.

LTrim

Delete source field characters starting from the left until a character from the set is found and copy the remaining string into the destination field.

Parameters:

characters

The string of characters to seek that stop the deletion.

RTrim

Delete source field characters starting from the right until a character from the set is found and copy the remaining string into the destination field.

Parameters:

characters

The string of characters to seek that stop the deletion.

LPad

Pad source field starting from the left for a given length and copy it into the destination field.

Parameters:

length	The padding length.
character	An optional character to pad with, default is `<space>`.

RPad

Pad source field starting from the right for a given length and copy it into the destination field.

Parameters:

length	The padding length.
character	An optional character to pad with, default is `<space>`.

Lookup XRef

Lookup the source field in a cross reference table and copy it into the destination field.

Parameters:

table	The cross reference table.
pass through	When there is no corresponding cross reference and this parameter is set to `true`, the destination field is set to the source field. If this parameter is set to `false`, the destination field is set to `null`.

Delete XRef

Delete the source field from a cross reference table.

Parameters:

table

The cross reference table.

Lookup DVM

Look up the source field in a domain value map table and copy it into the destination field.

Parameters:

table	The cross reference table.
pass through	When there is no corresponding domain value map and this parameter is set to `true`, the destination field is set to the source field. If this parameter is set to `false`, the destination field is set to `null`.

Truncate

Truncate source field starting from the right for a given length and copy it into the destination field.

Parameters:

length

The length to truncate.

Increment

Increment a counter and copy the incremented value into the destination field.

Parameters:

start value	The initial counter value.
counter	Give this counter a name to distinguish it from other counters that may be at different values at a given time and may have a different step size.
step size	The increment size.

C Transformations

Copy Fields

Parameters:

Copy Object

Parameters:

Concat Fields

Parameters:

Expand Fields

Parameters:

Set Constant

Parameters:

True Conditional Lookup XRef

Parameters:

True Conditional Lookup DVM

Parameters:

Conditional Copy

Parameters:

True Conditional Copy

Parameters:

True Conditional Concat

Parameters:

True Conditional To Number

Parameters:

False Conditional Copy

Parameters:

False Conditional Concat

Parameters:

False Conditional To Number

Parameters:

To Number

Parameters:

Substring

Parameters:

Char Replace

Parameters:

String Replace

Parameters:

LTrim

Parameters:

RTrim

Parameters:

LPad

Parameters:

RPad

Parameters:

Lookup XRef

Parameters:

Delete XRef

Parameters:

Lookup DVM

Parameters:

Truncate

Parameters:

Increment

Parameters:

C
Transformations