Data Transformation Engine Functions and Expressions Reference Guide

Chapter 2 - Using Functions List of Functions by Category
Functions and Expressions Reference Guide
52
Lookup and Reference Functions
Function Description
CHOOSE
Returns the object within a series whose position (index)
in the series corresponds to a specified number
DBLOOKUP
Executes an SQL statement against a database, returning
the results excluding the final column delimiter and row
terminator
Note Only available when used with a corresponding
database adapter.
DBQUERY
Executes an SQL statement against a database
Note Only available when used with a corresponding
database adapter.
DDEQUERY
Allows interfacing to other Windows applications
EXTRACT
Returns each member of a series for which a specified
condition is true
GETANDSET
Gets a fixed length value from the input data stream,
updates that value in the input data stream, and returns
either the original or updated value
GETDIRECTORY
Returns the full path (directory) for the compiled map or
the source or destination associated with a specified card
object
GETFILENAME
Returns the file name of a file source or target of a
specified card object
GETPARTITIONNAME
Returns a text item whose value is the name of the
partition to which the data belongs
GETRESOURCENAME
Returns the adapter source or target command of a
specified card object
INDEX
Returns an integer that represents the index of an object
relative to its nearest contained object, counting only valid
object