Data Transformation Engine Functions and Expressions Reference Guide

Functions and Expressions Reference Guide
3
Contents
About This Document
Related References........................................................................................... 8
Chapter 1 - Expressions and Evaluations
Expressions..................................................................................................... 9
Component Rule Expressions Evaluate to True or False .......................................... 9
Map Rule Expressions Evaluate to Data.............................................................10
Literals ........................................................................................................10
Data Object Names..........................................................................................11
Object Names in Map Rules...........................................................................11
Object Names in Component Rules..................................................................13
Card Name ...............................................................................................13
Local Type Name .......................................................................................14
Partition List.............................................................................................14
Component Path ........................................................................................ 14
Indexed Object Names.................................................................................15
Component Paths Separated by a Colon............................................................16
Component Paths Separated by IN .................................................................. 16
Comment Object Name................................................................................19
Shorthand Notation.....................................................................................19
Evaluating Expressions......................................................................................22
Card Order Can Influence the Order of Evaluation Sets ......................................... 23
Functions Influence the Number of Evaluation Sets.............................................. 24
Object Names Influence the Number of Evaluation Sets ........................................27
Operators .....................................................................................................29
Arithmetic Operators ..................................................................................29
Text Operators..........................................................................................29
Logical Operators.......................................................................................30
Comparison Operators .................................................................................30
Order of Operator Evaluation ........................................................................31
Operands .................................................................................................32
Using Functions in Expressions ............................................................................32
Function Arguments....................................................................................32
Input Arguments ........................................................................................33
Nested Input Arguments...............................................................................34
Output Arguments ......................................................................................34
Function Arguments and Evaluation.................................................................34
Map Names in Expressions..................................................................................35
Evaluation of Functional Maps in an Expression................................................... 36
Expressions That Evaluate to NONE ......................................................................37
When an Operand Evaluates to NONE...............................................................37
When an Input Argument of a Function Evaluates to NONE.....................................38
When an Input Argument of a Functional Map Evaluates to NONE.............................38
When an Input of an Executable Map Evaluates to NONE .......................................39
Impact of Track Setting on Order of Output.......................................................39
Evaluated Expressions Assigned to Output Items ......................................................40
NONE Assigned to an Output Number...............................................................40
Automatic Item Format Conversions .....................................................................40