The table below summarizes the intrinsic functions that are available.
The "arguments" column defines argument type and the "type" column defines the type of the function, as follows:
| Alph | means alphabetic |
| Anum | means alphanumeric |
| Int | means integer |
| Nat | means national |
| Num | means numeric |
| Function-Name | Arguments | Type | Value Returned |
|---|---|---|---|
| The ABS Function | Int1 or Num1 | Depends upon arguments | The absolute value of argument |
| The ACOS Function | Num1 | Num | Arccosine of Num1 |
| The ANNUITY Function | Num1, Int2 | Num | Ratio of annuity paid for Int2 periods at interest of Num1 to initial investment of one |
| The ASIN Function | Num1 | Num | Arcsine of Num1 |
| The ATAN Function | Num1 | Num | Arctangent of Num1 |
| The CHAR Function | Int1 | Anum | Character in position Int1 of the alphanumeric program collating sequence |
| The CHAR-NATIONAL Function | Int1 | Nat | Character in position Int1 of the national program collating sequence |
| The COS Function | Num1 | Num | Cosine of Num1 |
| The CURRENT-DATE Function | None | Anum | Current date and time and difference from Greenwich Mean Time |
| The DATE-OF-INTEGER Function | Int1 | Int | Standard date equivalent (YYYYMMDD) of integer date |
| The DATE-TO-YYYYMMDD Function | Int1, Int2 | Int | Argument-1 converted from YYMMDD to YYYYMMDD based on the value of argument-2 |
| The DAY-OF-INTEGER Function | Int1 | Int | Julian date equivalent (YYYYDDD) of integer date |
| The DAY-TO-YYYYDDD Function | Int1, Int2 | Int | Argument-1 converted from YYDDD to YYYYDDD based on the value of argument-2 |
| The DISPLAY-OF Function | Nat1,
|
Anum | Usage display representation of argument Nat1 |
| The E Function | None | Num | The value of e, the natural base |
| The EXP Function | Num1 | Num | e raised to the power Num1 |
| The EXP10 Function | Num1 | Num | 10 raised to the power Num1 |
| The FACTORIAL Function | Int1 | Int | Factorial of Int1 |
| The FRACTION-PART Function | Num1 | Num | Fraction part of Num1 |
| The INTEGER Function | Num1 | Int | The greatest integer not greater than Num1 |
| The INTEGER-OF-DATE Function | Int1 | Int | The integer date equivalent of standard date (YYYYMMDD) |
| The INTEGER-OF-DAY Function | Int1 | Int | The integer date equivalent of Julian date (YYYYDDD) |
| The INTEGER-PART Function | Num1 | Int | Integer part of Num1 |
| The LENGTH Function | Alph1 or Anum1
|
Int | Length of argument in number of character positions |
| The LENGTH-AN Function | Alph1 or Anum1 or Int1 or Nat1 or Num1 | Int | Length of argument in number of alphanumeric character positions |
| The LOG Function | Num1 | Num | Natural logarithm of Num1 |
| The LOG10 Function | Num1 | Num | Logarithm to base 10 of Num1 |
| The LOWER-CASE Function | Alph1 or Anum1
|
Depends upon argument* | All letters in the argument are set to lowercase |
| The MAX Function | Alph1 ... or Anum1 ... or Int1 ... or
|
Depends upon arguments* | Value of maximum argument |
| The MEAN Function | Num1 ... | Num | Arithmetic mean of arguments |
| The MEDIAN Function | Num1 ... | Num | Median of arguments |
| The MIDRANGE Function | Num1 ... | Num | Mean of minimum and maximum arguments |
| The MIN Function | Alph1 ... or Anum1 ... or Int1 ... or
|
Depends upon arguments* | Value of minimum argument |
| The MOD Function | Int1, Int2 | Int | Int1 modulo Int2 |
| The NATIONAL-OF Function | Anum1
|
Nat | Usage national representation of argument Anum1 |
| The NUMVAL Function | Anum1 or
|
Num | Numeric value of simple numeric string |
| The NUMVAL-C Function | Anum1 or Anum2
|
Num | Numeric value of numeric string with optional commas and currency string |
| The ORD Function | Alph1 or Anum1
|
Int | Ordinal position of the argument in collating sequence |
| The ORD-MAX Function | Alph1 ... or Anum1 ... or
|
Int | Ordinal position of maximum argument |
| The ORD-MIN Function | Alph1 ... or Anum1 ... or
|
Int | Ordinal position of minimum argument |
| The PI Function | None | Num | Value of |
| The PRESENT-VALUE Function | Num1, Num2 ... | Num | Present value of a series of future period-end amounts, Num2, at a discount rate of Num1 |
| The RANDOM Function | Int1 | Num | Random number |
| The RANGE Function | Int1 ... or Num1 | Depends upon arguments* | Value of maximum argument minus value of minimum arguments |
| The REM Function | Num1, Num2 | Num | Remainder of Num1/Num2 |
| The REVERSE Function | Alph1 or Anum1
|
Depends upon argument* | Reverse order of the characters of the argument |
| The SIGN Function | Num1 | Int | The sign of Num1 |
| The SIN Function | Num1 | Num | Sine of Num1 |
| The SQRT Function | Num1 | Num | Square root of Num1 |
| The STANDARD-DEVIATION Function | Num1 ... | Num | Standard deviation of arguments |
| The SUM Function | Int1 ... or Num1 ... | Depends upon arguments | Sum of arguments |
| The TAN Function | Num1 | Num | Tangent of Num1 |
| The ULENGTH Function | Alph1 or Anum1 | Int | Number of characters in Alph1 or Anum1 |
| The UPOS Function | Alph1 or Anum1, Int1 | Int | Position of nth UTF-8 char in Alph1 or Anum1 |
| The UPPER-CASE Function | Alph1 or Anum1
|
Depends upon argument* | All letters in the argument are set to uppercase |
| The USUBSTR Function | Alph1 or Anum1, Num1, Num2 | Anum | Substring of a character string argument that is encoded in UTF-8 |
| The USUPPLEMENTARY Function | Alph1 or Anum1
|
Int | Integer value that is equal to the index of the first Unicode supplementary character in a character string argument that is encoded in UTF-8 or UTF-16 |
| The UVALID Function | Alph1 or Anum1
|
Int | Zero if character string consists of valid Unicode UTF-8 or UTF-16 data; non-zero if not. |
| The UWIDTH Function | Alph1 or Anum1, Int1 | Int | integer value that is equal to the width in bytes of the nth UTF-8 character in a character string |
| The VARIANCE Function | Num1 ... | Num | Variance of argument |
| The WHEN-COMPILED Function | None | Anum | Date and time program was compiled |
| The YEAR-TO-YYYY Function | Int1, Int2 | Int | Argument-1 converted from YY to YYYY based on the value of argument-2 |
* A function that has only alphabetic arguments is type alphanumeric.