Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference SEARCHDOWN
Functions and Expressions Reference Guide
176
" -OE2" Using the output echo command option, the data built for
output card 2 of the DoOneSet map will be returned as the
result of the
RUN function.
Uses
Use
RUN to dynamically name source and/or destination files or to dynamically
pass data to a map.
Another possible use of
RUN is to split the output data into separate files based
on some value in the input.
Related Functions
DDEQUERY
SEARCHDOWN
The SEARCHDOWN function performs a binary search on a series sorted in ASCII
descending order, returning a related object that corresponds to the item found.
Syntax
SEARCHDOWN (series-object-expression , series-item-object-
expression , single-item-expression)
Meaning
SEARCHDOWN (corresponding_object_to_return ,
descending_items_to_search , item_to_match)
Returns
This function returns a single-object.
Performs a binary search on the item series of descending_items_to_search.
The descending_items_to_search must be sorted in ASCII descending order.
The value to search for is specified as the item_to_match. The object returned
(corresponding_object_to_return) must be related to
descending_items_to_search by a common object name.
If no match is found,
SEARCHDOWN returns NONE.