The following table lists the available functions.
The "Arguments" column defines type and number of arguments as follows:
A | alphabetic |
I | integer |
Ind | index |
Nat | national |
Num | numeric |
O | object reference |
P | pointer |
T | type declaration |
X | alphanumeric1 |
1 X in the "Arguments" column contains stongly typed group items. If the argument type deter-mines the function type, then the function is alphanumeric as soon as just one of its arguments is strongly typed. This also applies if all the function’s arguments are of the same type. Strongly typed arguments are excluded for the ADDR, MAX, MIN, ORD-MAX and ORD-MIN functions.
The "Type" column defines function type as follows:
I | integer |
Ind | index |
Nat | national |
Num | numeric |
X | alphanumeric |
Function-name | Arguments | Type | Returned value |
ACOS | Num1 | Num | Arccosine of Num1 |
ADDR | A1 or | I | Address of the argument |
ANNUITY | Num1, I2 | Num | Ratio of annuity paid for 12 periods at interest of Num1 to initial investment of one |
ASIN | Num1 | Num | Arcsine of Num1 |
ATAN | Num1 | Num | Arctangent of Num1 |
BYTE-LENGTH | A1 or | I | Length of the arguments in bytes |
CHAR | I1 | X | Character in position I1 of the alphanumeric collating sequence |
CHAR-NATIONAL | I1 | Nat | Character in position I1 of the national collating sequence |
COS | Num1 | Num | Cosine of Num1 |
CURRENT-DATE | None | X | Current data and time |
DATE-OF-INTEGER | I1 | Standard date equivalent (YYYYMMDD) of integer date (number of days) | |
DATE-TO-YYYYMMDD | I1, I2 | I | YYYYMMDD equivalent, depending on the value of I2, of I1 from a standard date with a 2-digit year (YYMMDD) |
DAY-OF-INTEGER | I1 | I | Julian date equivalent (YYYYDDD) of integer data |
DAY-TO-YYYYDDD | I1, I2 | I | YYYYDDD equivalent, depending on the value of I2, of I1 from a standard Julian date (YYDDD) |
DISPLAY-OF | Nat1, X2 | X | alphanumeric display the national character set Nat1 |
EXCEPTION-STATUS | none | X | Name of the last exception status |
FACTORIAL | I1 | I | Factorial of I1 |
INTEGER | Num1 | I | Greatest integer not greater than Num1 |
INTEGER-OF-DATE | I1 | I | Integer data equivalent of standard date (YYYYMMDD) |
INTEGER-OF-DAY | I1 | I | Integer date equivalent of Julian date (YYYYDDD) |
INTEGER-PART | Num1 | I | Integer part of Num1 |
LENGTH | A1 or | I | Length of argument in characters |
LOG | Num1 | Num | Natural logarithm of Num1 |
LOG10 | Num1 | Num | Logarithm to base 10 of Num1 |
LOWER-CASE | A1 or | Nat | All letters in the argument are set to lowercase |
MAX | A1... or | X | Value of maximum argument |
MEAN | Num1... | Num | Arithmetic mean of arguments |
MEDIAN | Num1... | Num | Median of arguments |
MIDRANGE | Num1... | Num | Mean of minimum and maximum arguments |
MIN | A1... or | X | Value of minimum argument |
MOD | I1, I2 | I | I1 modulo I2 |
NATIONAL-OF | X1, Nat2 | Nat | National display of the alphanumeric character set X1 |
NUMVAL | Nat1 or | Num | Numeric value of simple numeric string |
NUMVAL-C | Nat1 or | Num | Numeric value of numeric string with optional commas and currency sign |
ORD | A1 or | I | Ordinal position of A1 / X1 in collating sequence |
ORD-MAX | A1... or | I | Ordinal position of maximum argument |
ORD-MIN | A1... or | I | Ordinal position of minimum argument |
PRESENT-VALUE | Num1 | Num | Principal amount repaid by a series of deferred payments, Num2, at an interest rate of Num1 |
RANDOM | I1 | Num | Random number |
RANGE | I1... or | I Num | Value of maximum argument minus value of minimum argument |
REM | Num1, | Num | Remainder of Num1/Num2 |
REVERSE | A1 or | Nat | Reverse order of the characters of the argument |
SIN | Num1 | Num | Sine of Num1 |
SQRT | Num1 | Num | Square root of Num1 |
STANDARD-DEVIATION | Num1... | Num | Standard deviation of arguments |
SUM | I1... or | I | Sum of arguments |
TAN | Num1 | Num | Tangent of Num1 |
UPPER-CASE | A1 or | Nat | All letters in the argument are set to uppercase |
VARIANCE | Num1... | Num | Variance of arguments |
WHEN-COMPILED | None | X | Date and time program was compiled |
YEAR-TO-YYYY | I1, I2 | I | 4-digit equivalent, depending on the value of I2, of the 2-digit year I1 |