Data Transformation Engine Functions and Expressions Reference Guide

Functions and Expressions Reference Guide
255
Index
$
$
in a component rule, 20
reserved symbol, 231
(
() reserved symbol, 231
:
: reserved symbol, 231
:.: reserved symbol, 231
@
@ reserved symbol, 19, 231
[
[ ] reserved symbol, 15, 231
{
{} reserved symbol, 231
<
< > reserved symbol, 14, 231
<comma> reserved symbol, 231
<space>, reserved symbol, 233
A
ABS function, 57
ABSENT function, 59
ADDDAYS function, 60
ADDHOURS function, 62, 64
ALL function, 65
ANY, reserved word, 232
arguments
of a function, 31
arithmetic operators, 28
B
BCDTOHEX function, 66
BCDTOINT function, 68
BCDTOTEXT function, 70
bound objects
in an expression, 26
C
card name
in an expression, 13
CHOOSE function, 72
CLONE function, 73
colon
in a component path, 16
comment name, 19
comparison operators, 29
component
in a component list, 16
in an expression, 16
component path, 13, 14
COMPONENT reserved word, 232
CONTAINSERRORS function, 74
CONVERT function, 76
COUNT function, 77
COUNTABS function, 78
COUNTSTRING function, 79
CURRENTDATE function, 80
CURRENTDATETIME function, 81
CURRENTTIME function, 83
D
DATETONUMBER function, 84
DATETOTEXT function, 85
DBLOOKUP function, 86
DBQUERY function, 90
DDEQUERY function, 94
DEFAULT function, 96
E
ECHOIN function, 97
EITHER function, 98
evaluation
of component rules, 21
of expressions, 21
of functional maps, 35
of functions, 31
of map rules, 10, 21
influence of card order, 21
influence of functions, 23
influence of object names, 26
of operands, 31
EXIT function, 100
expressions
bound objects in, 21
definition of, 9
evaluating, 21
functional map names in, 34
operators in, 28