Your Browser is not longer supported

Please use Google Chrome, Mozilla Firefox or Microsoft Edge to view the page correctly
Loading...

{{viewport.spaceProperty.prod}}

Overview of intrinsic functions

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
Ind1
Nat1 or
Num1 or
X1

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
Ind1 or
N1 or
Nat1 or
O1 or
P1 or
T1 or
X1

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
Ind1 or
Nat1 or
Num1 or
X1 or
T1

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
Nat1 or
X1

Nat
X

All letters in the argument are set to lowercase

MAX

A1... or
I1... or
Ind1or
Nat1... or
Num1... or
X1...

X
I
Ind
Nat
Num
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
I1... or
Ind1 or
Nat1... or
Num1... or
X1...

X
I
Ind
Nat
Num
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
X1

Num

Numeric value of simple numeric string

NUMVAL-C

Nat1 or
Nat2 or
X1, X2

Num

Numeric value of numeric string with optional commas and currency sign

ORD

A1 or
Nat1 or
X1

I

Ordinal position of A1 / X1 in collating sequence

ORD-MAX

A1... or
Ind1 or
Nat1... or
Num1... or
X1...

I

Ordinal position of maximum argument

ORD-MIN

A1... or
Ind1 or
Nat1... or
Num1... or
X1...

I

Ordinal position of minimum argument

PRESENT-VALUE

Num1
Num2...

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
Num1...

I

Num

Value of maximum argument minus value of minimum argument

REM

Num1,
Num2

Num

Remainder of Num1/Num2

REVERSE

A1 or
Nat1 or
X1

Nat
X

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
Num1...

I
Num

Sum of arguments

TAN

Num1

Num

Tangent of Num1

UPPER-CASE

A1 or
Nat1 or
X1

Nat
X

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