Data Transformation Engine Functions and Expressions Reference Guide

Chapter 1 - Expressions and Evaluations Automatic Item Format Conversions
Functions and Expressions Reference Guide
40
♦ Missing part of an output date format. If a portion of the format of an
output date cannot be derived from the input date, the missing part will have
pound characters (#) in its place. For example, if
09/98 is the date for an
input with a format string of MM/YY and that date was mapped to an output
date with a format of MM/DD/YY, the output date would be built as
09/##/98.
♦ Missing part of an output time format. If a portion of the format of an
output time cannot be derived from the input time, the missing part will have
zeroes (0) in its place. For example, if
12:14 is the data for an input with a
format string of HH12:MM and that time was mapped to an output time with a
format of HH:MM:SS, the output date would be built as
12:14:00.
To convert a number to text, a date or time, or vice versa, you must use a
function to perform the conversion. For example, to convert a date to text, use
the function
DATETOTEXT.
Numeric Precision
All numbers in the input and numeric literals in map rules are converted to
multiple precision and converted to the format required at output time.
♦ If the multiple precision number does not overflow and will not fit into the
maximum size of a numeric item, that item is filled with the number sign
character ("#") up to its maximum size.
♦ An arithmetic overflow is recognized when an arithmetic expression includes:
! Divide by zero
! A multiple precision number greater than 1.0E254
1 Arithmetic overflow is designated in the output object with up to a maximum of
ten number sign (#) characters.