Data Transformation Engine Functions and Expressions Reference Guide

Chapter 2 - Using Functions List of Functions by Category
Functions and Expressions Reference Guide
43
Term Explanation
object-name The name of a data object, as defined in Chapter 1, Data
Object Names. If an object name is further limited, it is
specified as a prefix. For example, simple-object-name
refers to a simple type name.
... Indicates that the function can take on any number of
additional similar arguments.
[ ] Indicate that the argument is optional.
{ literal , literal
...}
An enumerated series of literals.
In the list of functions, the syntax specification shows each input argument, using
terms as described in the previous table, preceded by the word "single" or
"series". For example,
Syntax
ALL ( series-condition-expression )
Next, the arguments are defined using a name that describes its use by the
function. A simple example is:
Meaning
DATETONUMBER ( date_to_convert )
Note Function names are shown in UPPERCASE letters in this manual. However, function
names are not case-sensitive.
List of Functions by Category
The following tables list the functions by category. Some functions are listed in
more than one category.
Math and Statistics Functions
Function Description
ABS
Returns the absolute value of a number
COUNT
Counts the number of valid objects in a series