
120
Chapter 7
E Double-click or click the yellow arrow bu tton to add the field or function to the expression field.
E Use the operand buttons in the center of the dialog box to insert the operatio ns into the expression.
Selecting Functions
The function list displays all available CLEM fu nctions and operators. Scroll to select a function
from t he list, o r, for easier searching, use the drop-dow n list to display a subset of functions or
operators. Available functions are grouped into categor ies for easier searching.
Figure 7-7
Functions drop-down list
Most of these categorie s are described in the R eference section of the CLEM language descrip tion.
For more information, see the to pic Funct ions Reference in Chapter 8 o n p. 133.
The other categories are as follows.
General Functions
contains a selection of some of the most commonly-us ed functions.
Recently Used
contains a lis t of CLEM fu nctions used within the current session.
@ Functions
contains a list of all the special functions, whi ch have their names preceded
by an “@” sign.
Database Functions
. If the stream includes a database co nnection (by means o f a Database
source node), this selection lists the fun ctions available from within that database, including
user-defined functions (UDFs).
Operators
lists all the ope r ators you can use when building expressions. Operators are also
availabl e from the buttons in the center of the dialog box.
All Functions
contains a complete list of available CLEM functio
ns.
Commenti su questo manuale