| Function |
Description |
| ABS or ABSVAL |
Returns the absolute value of a number. |
| ACOS |
Returns the arc cosine of a number, in radians. |
| ASIN |
Returns the arc sine of a number, in radians. |
| ATAN |
Returns the arc tangent of a number, in radians. |
| ATANH |
Returns the hyperbolic arc tangent of a number, in radians. |
| ATAN2 |
Returns the arc tangent of x and y coordinates as an angle expressed in radians. |
| CEILING or CEIL |
Returns the smallest integer value that is greater than or equal to a number. |
| COMPARE_DECFLOAT |
Returns a SMALLINT value that indicates whether the two arguments are equal or unordered, or whether one argument is greater than the
other. |
| COS |
Returns the cosine of a number. |
| COSH |
Returns the hyperbolic cosine of a number. |
| COT |
Returns the cotangent of the argument, where the argument is an angle expressed in radians. |
| DECFLOAT_FORMAT |
Returns a DECFLOAT(34) from a character string. |
| DEGREES |
Returns the number of degrees of an angle. |
| DIGITS |
Returns a character-string representation of the absolute value of a number. |
| EXP |
Returns a value that is the base of the natural logarithm (e) raised to a power specified by the argument. |
| FLOOR |
Returns the largest integer value that is less than or equal to a number. |
| LN |
Returns the natural logarithm of a number. |
| LOG10 |
Returns the common logarithm (base 10) of a number. |
| MOD |
Returns the remainder of the first argument divided by the second argument. |
| MOD (SYSFUN schema) |
Returns the remainder of the first argument divided by the second argument. |
| MULTIPLY_ALT |
Returns the product of two arguments as a decimal value.
This function is useful when the sum of the argument precisions is greater than 31. |
| NORMALIZE_DECFLOAT |
Returns a decimal floating-point value that is the result of the argument set to its simplest form. |
| POW |
Returns the result of raising the first argument to the power of the second argument. |
| POWER |
Returns the result of raising the first argument to the power of the second argument. |
| QUANTIZE |
Returns a decimal floating-point number that is equal in value and sign to the first argument, and whose exponent is equal to the
exponent of the second argument. |
| RADIANS |
Returns the number of radians for an argument that is expressed in degrees. |
| RANDOM |
Returns a floating point value between 0 and 1. |
| RAND (SYSFUN schema) |
Returns a random number. |
| RAND (SYSIBM schema) |
Returns a floating point value between 0 and 1. |
| ROUND |
Returns a numeric value that has been rounded to the specified number of decimal places. |
| SIGN |
Returns the sign of a number. |
| SIN |
Returns the sine of a number. |
| SINH |
Returns the hyperbolic sine of a number. |
| SQRT |
Returns the square root of a number. |
| TAN |
Returns the tangent of a number. |
| TANH |
Returns the hyperbolic tangent of a number. |
| TO_NUMBER |
Returns a DECFLOAT(34) from a character string. |
| TOTALORDER |
Returns a SMALLINT value of -1, 0, or 1 that indicates the comparison order of two arguments. |
| TRUNCATE or TRUNC |
Returns a number value that has been truncated at a specified number of decimal places. |
| VARCHAR_FORMAT |
Returns a CHARACTER representation of a timestamp (argument1), formatted according to a template (argument2). |
| WIDTH_BUCKET |
Creates equal-width histograms. |
