Data Transformation Engine Functions and Expressions Reference Guide

Chapter 2 - Using Functions List of Functions by Category
Functions and Expressions Reference Guide
47
Function Description
item
STREAMTOHEXTEXT
Returns a character text stream represented by hex pairs
whose value is the evaluation of input binary text
SYMBOL
Returns a character that is the ASCII character equivalent
of a specified decimal value
TEXTTOBCD
Converts a text item from decimal digits to binary coded
decimal (BCD) format
TEXTTODATE
Converts text that is in CCYYMMDD or YYMMDD
presentation to a date that looks like the text item
TEXTTONUMBER
Converts an object defined as text to an object defined as a
character number item
TEXTTOTIME
Converts an object defined as text to an object defined as
time
TIMETOTEXT
Converts a time object or expression to a text item
TOBASETEN
Converts a text item that can be interpreted as a number,
using positional notation of the base specified, to a base 10
number
TODATETIME
Converts a text string of a specified format to a date/time
TONUMBER
Converts a text string of a specified format to a number
UNPACK
Converts text that can be interpreted as a packed decimal
number to a signed integer item
UNZONE
Converts a text item that can be interpreted as a zoned
number to an integer item that has no superimposed sign in
the rightmost byte
ZONE
Converts a signed integer item to a text item that can be
interpreted as a number with a superimposed sign in the
rightmost byte