CONNX Data Integration Suite
14.8.0 |
Reference Guide
|
SQL Grammar
|
SQL Numeric Functions
|
Quick Links to SQL Numeric Functions
Quick Links to SQL Numeric Functions
"A" Functions
ABS(numeric_exp)
ACOS(float_exp)
ASIN(float_exp)
ATAN(float_exp)
ATAN2(float_exp1, float_exp2)
"C" Functions
CEILING(numeric_exp)
COS(float_exp)
COT(float_exp)
"D" Functions
DEGREES(numeric_exp)
"E" Functions
EXP(float_exp)
"F" Functions
FLOOR(numeric_exp)
"L" Functions
LOG(float_exp)
LOG10(float_exp)
"M" Functions
MOD(integer_exp1, integer_exp2)
"P" Functions
PI()
POWER(numeric_exp, integer_exp)
"R" Functions
RADIANS(numeric_exp)
RAND(integer_exp)
ROUND(numeric_exp, integer_exp)
"S" Functions
SIGN(numeric_exp)
SIN(float_exp)
SQRT(float_exp)
"T" Functions
TAN(float_exp)
TRUNCATE(numeric_exp, integer_exp)
"X" Functions
XOR(numeric_exp, numeric_exp, ...)
XOR64(numeric_exp, numeric_exp)