Decision Transformation Functions
The Decision transformation provides access to predefined functions that you use to define decision strategies.
The Decision transformation expression editor contains a Decision folder. This folder contains functions that are specific to the Decision transformation. The editor also contains other folders that provide access to Expression transformation functions.
When you click a function in the expression editor, the transformation displays the usage and datatypes for the function, in addition to a description of what the function does.
Note: Not all Expression transformation functions are compatible with the Decision transformation. The Decision transformation only provides access to compatible Expression transformation functions.
List of Decision Transformation Functions
- •ABS
- •ADD_TO_DATE
- •ASCII
- •CEIL
- •CHOOSE
- •CHR
- •CHRCODE
- •CONCAT
- •CONTAINS
- •CONVERT_BASE
- •COS
- •COSH
- •CRC32
- •CUME
- •CURDATE
- •CURTIME
- •DATE_COMPARE
- •DATE_DIFF
- •DATECONVERT
- •EXP
- •FLOOR
- •FV
- •GET_DATE_PART
- •GREATEST
- •IN
- •INDEXOF
- •INITCAP
- •INSTR
- •IS_DATE
- •IS_NUMBER
- •ISNULL
- •LAST_DAY
- •LEAST
- •LEFTSTR
- •LENGTH
- •LN
- •LOG
- •LOWER
- •LPAD
- •LTRIM
- •MAKE_DATE_TIME
- •MAX
- •MD5
- •METAPHONE
- •MIN
- •MOD
- •MONTHCOMPARE
- •MOVINGAVG
- •MOVINGSUM
- •NPER
- •PMT
- •POWER
- •PV
- •RAND
- •RATE
- •REG_EXTRACT
- •REG_MATCH
- •REG_REPLACE
- •REPLACECHR
- •REPLACESTR
- •REVERSE
- •RIGHTSTR
- •ROUND
- •RPAD
- •RTRIM
- •SET_DATE_PART
- •SIGN
- •SIN
- •SINH
- •SOUNDEX
- •SQRT
- •SUBSTR
- •TAN
- •TANH
- •TIMECOMPARE
- •TO_CHAR
- •TO_DATE
- •TO_FLOAT
- •TO_INTEGER
- •TRUNC
- •UPPER
- •XOR
Note: Use a constant value to define the date format in the CURDATE, DATE_COMPARE, DATECONVERT, and MONTHCOMPARE functions in the Decision transformation.