Data Transformation Engine Functions and Expressions Reference Guide

Chapter 2 - Using Functions List of Functions by Category
Functions and Expressions Reference Guide
53
Function Description
INDEXABS
Returns an integer that represents the index of an object
relative to its nearest contained object, counting both valid
and invalid instances of the object
LASTERRORCODE
Returns a text item whose value is the last error code
returned by one of a specified set of functions during map
execution
LASTERRORMSG
Returns a text item whose value is the message
corresponding to the last error code returned by one of a
specified set of functions during map execution
LOOKUP
Sequentially searches a series, returning the first member
that meets a specified condition
MEMBER
Looks for a specified object in a series. If found, returns
TRUE; otherwise, returns FALSE
SEARCHDOWN
Performs a binary search on a series sorted in descending
order, returning a related object that corresponds to the
item found
SEARCHUP
Performs a binary search on a series sorted in ASCII
ascending order, returning a related object that
corresponds to the item found
SORTDOWN
Returns a series containing the values from an input series
in ASCII descending order
SORTUP
Returns a series containing the values from an input series
in ASCII ascending order
UNIQUE
Searches a series, returning all members that are unique
External Interface Functions
Function Description
DBLOOKUP
Executes an SQL statement against a database, returning
the results excluding the final column delimiter and row
terminator
DBQUERY
Executes an SQL statement against a database
DDEQUERY
Allows interfacing to other Windows applications