The following tables show the mathematical operations and expressions that
support SQL generation and are often used during data mining. Operations absent from these tables do
not support SQL generation in the current release.
Table 1. Operators
| Operation supporting SQL generation |
Notes |
| + |
|
| - |
|
| / |
|
| * |
|
| >< |
Used to concatenate strings. |
Table 2. Relational operators
| Operation supporting SQL generation |
Notes |
| = |
|
| /= |
Used to specify “not equal.” |
| > |
|
| >= |
|
| < |
|
| <= |
|
Table 3. Functions
| Operation supporting SQL generation |
Notes |
abs
|
|
allbutfirst
|
|
allbutlast
|
|
and
|
|
arccos
|
|
arcsin
|
|
arctan
|
|
arctanh
|
|
cos
|
|
div
|
|
exp
|
|
fracof
|
|
hasstartstring
|
|
hassubstring
|
|
integer
|
|
intof
|
|
isaplhacode
|
|
islowercode
|
|
isnumbercode
|
|
isstartstring
|
|
issubstring
|
|
isuppercode
|
|
last
|
|
length
|
|
locchar
|
|
log
|
|
log10
|
|
lowertoupper
|
|
max
|
|
member
|
|
min
|
|
negate
|
|
not
|
|
number
|
|
or
|
|
pi
|
|
real
|
|
rem
|
|
round
|
|
sign
|
|
sin
|
|
sqrt
|
|
string
|
|
strmember
|
|
subscrs
|
|
substring
|
|
substring_between
|
|
uppertolower
|
|
to_string
|
|
Table 4. Special functions
| Operation supporting SQL generation |
Notes |
@NULL
|
|
@GLOBAL_AVE
|
The special global functions are used to retrieve global values computed by the Set Globals
node. |
@GLOBAL_SUM
|
|
@GLOBAL_MAX
|
|
@GLOBAL_MEAN
|
|
@GLOBAL_MIN
|
|
@GLOBALSDEV
|
|
Table 5. Aggregate functions
| Operation supporting SQL generation |
Notes |
Sum
|
|
Mean
|
|
Min
|
|
Max
|
|
Count
|
|
SDev
|
|