Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference DEFAULT
Functions and Expressions Reference Guide
96
DEFAULT
The DEFAULT function allows a pre-defined value to be introduced into an
expression.
DEFAULT returns the value assigned as the default value when the type was
defined. Typically used with the EITHER function.
Syntax
DEFAULT(single-type-expression)
Meaning
DEFAULT(type_whose_defined_default_value_is_desired)
This function returns a single-object.
Example
In this example, the defined default value for ZipCode is returned.
DEFAULT(ZipCode)
When used with EITHER, DEFAULT might appear like this:
EITHER( ZipCode,DEFAULT( ZipCode))
If the first argument evaluates to a value other than NONE, that value is used.
If the first argument evaluates to
NONE, the default value for ZipCode is used.