Intrinsic Functions Syntax
=======================================================================
ABS Function Syntax
=======================================================================
ABS | ABSOLUTE-VALUE (argument-1)
~~~ ~~~~~~~~~~~~~~
=======================================================================
ACOS Function Syntax
=======================================================================
ACOS(argument-1)
~~~~
=======================================================================
ANNUITY Function Syntax
=======================================================================
ANNUITY(interest-rate, number-of-periods)
~~~~~~~
=======================================================================
ASIN Function Syntax
=======================================================================
ASIN(argument-1)
~~~~
=======================================================================
ATAN Function Syntax
=======================================================================
ATAN(argument-1)
~~~~
=======================================================================
BIT-OF Function Syntax
=======================================================================
BIT-OF (argument-1)
~~~~~~
=======================================================================
BIT-TO-CHAR Function Syntax
=======================================================================
BIT-TO-CHAR {argument-1)
~~~~~~~~~~~
=======================================================================
BOOLEAN-OF-INTEGER function Syntax
=======================================================================
BOOLEAN-OF-INTEGER(argument-1 argument-2)
~~~~~~~~~~~~~~~~~~
=======================================================================
BYTE-LENGTH Function Syntax
=======================================================================
BYTE-LENGTH(string)
~~~~~~~~~~~
=======================================================================
CHAR Function Syntax
=======================================================================
CHAR(integer)
~~~~
=======================================================================
CHAR-NATIONAL Function Syntax
=======================================================================
CHAR-NATIONAL(argument-1)
~~~~~~~~~~~~~
=======================================================================
COMBINED-DATETIME Function Syntax
=======================================================================
COMBINED-DATETIME(days, seconds)
~~~~~~~~~~~~~~~~~
=======================================================================
CONCATENATE Function Syntax
=======================================================================
CONCAT | CONCATENATE (argument-1 [, argument-2 ]...)
~~~~~~ ~~~~~~~~~~~
=======================================================================
CONTENT-LENGTH Function Syntax
=======================================================================
CONTENT-LENGTH argument-1
~~~~~~~~~~~~~~
=======================================================================
CONTENT-OF Function Syntax
=======================================================================
CONTENT-OF pointer-1 { length }
~~~~~~~~~~
=======================================================================
COS Function Syntax
=======================================================================
COS(argument-1)
~~~
=======================================================================
CURRENCY-SYMBOL Function Syntax
=======================================================================
CURRENCY-SYMBOL
~~~~~~~~~~~~~~~
=======================================================================
CURRENT-DATE Function Syntax
=======================================================================
CURRENT-DATE
~~~~~~~~~~~~
=======================================================================
DATE-OF-INTEGER Function Syntax
=======================================================================
DATE-OF-INTEGER(integer)
~~~~~~~~~~~~~~~
=======================================================================
DATE-TO-YYYYMMDD Function Syntax
=======================================================================
DATE-TO-YYYYMMDD(yymmdd [, yy-cutoff [, yy-execution-time ]])
~~~~~~~~~~~~~~~~
=======================================================================
DAY-OF-INTEGER Function Syntax
=======================================================================
DAY-OF-INTEGER(integer)
~~~~~~~~~~~~~~
=======================================================================
DAY-TO-YYYYDDD Function Syntax
=======================================================================
DAY-TO-YYYYDDD(yyddd [, yy-cutoff [, yy-execution-time ]])
~~~~~~~~~~~~~~
=======================================================================
DISPLAY-OF Function Syntax
=======================================================================
DISPLAY-OF(argument-1 [ argument-2] )
~~~~~~~~~~
=======================================================================
E Function Syntax
=======================================================================
E
~
=======================================================================
EXCEPTION-FILE Function Syntax
=======================================================================
EXCEPTION-FILE
~~~~~~~~~~~~~~
=======================================================================
EXCEPTION-FILE-N Function Syntax
=======================================================================
EXCEPTION-FILE-N
~~~~~~~~~~~~~~~~
=======================================================================
EXCEPTION-LOCATION Function Syntax
=======================================================================
EXCEPTION-LOCATION
~~~~~~~~~~~~~~~~~~
=======================================================================
EXCEPTION-LOCATION-N Function Syntax
=======================================================================
EXCEPTION-LOCATION-N
~~~~~~~~~~~~~~~~~~~~
=======================================================================
EXCEPTION-STATEMENT Function Syntax
=======================================================================
EXCEPTION-STATEMENT
~~~~~~~~~~~~~~~~~~~
=======================================================================
EXCEPTION-STATUS Function Syntax
=======================================================================
EXCEPTION-STATUS
~~~~~~~~~~~~~~~~
=======================================================================
EXP Function Syntax
=======================================================================
EXP(number)
~~~
=======================================================================
EXP10 Function Syntax
=======================================================================
EXP10(number)
~~~~~
=======================================================================
FACTORIAL Function Syntax
=======================================================================
FACTORIAL(number)
~~~~~~~~~
=======================================================================
FORMATTED-CURRENT-DATE Function Syntax
=======================================================================
FORMATTED-CURRENT-DATE ( argument-1 )
~~~~~~~~~~~~~~~~~~~~~~
=======================================================================
FORMATTED-DATE Function Syntax
=======================================================================
FORMATTED-DATE ( argument-1, argument-2 )
~~~~~~~~~~~~~~
=======================================================================
FORMATTED-DATETIME Function Syntax
=======================================================================
FORMATTED-DATETIME ( argument-1, argument-2, argument-3, argument-4 )
~~~~~~~~~~~~~~~~~~
=======================================================================
FORMATTED-TIME Function Syntax
=======================================================================
FORMATTED-TIME ( argument-1, argument-2, argument-3 )
~~~~~~~~~~~~~~
=======================================================================
FRACTION-PART Function Syntax
=======================================================================
FRACTION-PART(number)
~~~~~~~~~~~~~
=======================================================================
HEX-OF Function Syntax
=======================================================================
HEX-OF {argument-1)
~~~~~~
=======================================================================
HEX-TO-CHAR Function Syntax
=======================================================================
HEX-TO-CHAR {argument-1)
~~~~~~~~~~~
=======================================================================
HIGHEST-ALGEBRAIC Function Syntax
=======================================================================
HIGHEST-ALGEBRAIC(numeric-identifier)
~~~~~~~~~~~~~~~~~
=======================================================================
INTEGER Function Syntax
=======================================================================
INTEGER(number)
~~~~~~~
=======================================================================
INTEGER-OF-BOOLEAN Function Syntax
=======================================================================
INTEGER-OF-BOOLEAN(argument-1)
~~~~~~~~~~~~~~~~~~
=======================================================================
INTEGER-OF-DATE Function Syntax
=======================================================================
INTEGER-OF-DATE(date)
~~~~~~~~~~~~~~~
=======================================================================
INTEGER-OF-DAY Function Syntax
=======================================================================
INTEGER-OF-DAY(date)
~~~~~~~~~~~~~~
=======================================================================
INTEGER-OF-FORMATTED-DATE Function Syntax
=======================================================================
INTEGER-OF-FORMATTED-DATE ( argument-1, argument-2 )
~~~~~~~~~~~~~~~~~~~~~~~~~
=======================================================================
INTEGER-PART Function Syntax
=======================================================================
INTEGER-PART(number)
~~~~~~~~~~~~
=======================================================================
LENGTH Function Syntax
=======================================================================
LENGTH(string)
~~~~~~
=======================================================================
LENGTH-AN Function Syntax
=======================================================================
LENGTH-AN(string)
~~~~~~~~~
=======================================================================
LOCALE-COMPARE Function Syntax
=======================================================================
LOCALE-COMPARE(argument-1, argument-2 [ , locale ])
~~~~~~~~~~~~~~
=======================================================================
LOCALE-DATE Function Syntax
=======================================================================
LOCALE-DATE(date [, locale ])
~~~~~~~~~~~
=======================================================================
LOCALE-TIME Function Syntax
=======================================================================
LOCALE-TIME(time [, locale ])
~~~~~~~~~~~
=======================================================================
LOCALE-TIME-FROM-SECONDS Function Syntax
=======================================================================
LOCALE-TIME-FROM-SECONDS(seconds [, locale ])
~~~~~~~~~~~~~~~~~~~~~~~~
=======================================================================
LOG Function Syntax
=======================================================================
LOG(number)
~~~
=======================================================================
LOG10 Function Syntax
=======================================================================
LOG10(number)
~~~~~
=======================================================================
LOWER-CASE Function Syntax
=======================================================================
LOWER-CASE(string)
~~~~~~~~~~
=======================================================================
LOWEST-ALGEBRAIC Function Syntax
=======================================================================
LOWEST-ALGEBRAIC(numeric-identifier)
~~~~~~~~~~~~~~~~
=======================================================================
MAX Function Syntax
=======================================================================
MAX(number-1 [, number-2 ]...)
~~~
=======================================================================
MEAN Function Syntax
=======================================================================
MEAN(number-1 [, number-2 ]...)
~~~~
=======================================================================
MEDIAN Function Syntax
=======================================================================
MEDIAN(number-1 [, number-2 ]...)
~~~~~~
=======================================================================
MIDRANGE Function Syntax
=======================================================================
MIDRANGE(number-1 [, number-2 ]...)
~~~~~~~~
=======================================================================
MIN Function Syntax
=======================================================================
MIN(number-1 [, number-2 ]...)
~~~
=======================================================================
MOD Function Syntax
=======================================================================
MOD(value, modulus)
~~~
=======================================================================
MODULE-CALLER-ID Function Syntax
=======================================================================
MODULE-CALLER-ID
~~~~~~~~~~~~~~~~
=======================================================================
MODULE-DATE Function Syntax
=======================================================================
MODULE-DATE
~~~~~~~~~~~
=======================================================================
MODULE-FORMATTED-DATE Function Syntax
=======================================================================
MODULE-FORMATTED-DATE
~~~~~~~~~~~~~~~~~~~~~
=======================================================================
MODULE-ID Function Syntax
=======================================================================
MODULE-ID
~~~~~~~~~
=======================================================================
MODULE-PATH Function Syntax
=======================================================================
MODULE-PATH
~~~~~~~~~~~
=======================================================================
MODULE-SOURCE Function Syntax
=======================================================================
MODULE-SOURCE
~~~~~~~~~~~~~
=======================================================================
MODULE-TIME Function Syntax
=======================================================================
MODULE-TIME
~~~~~~~~~~~
=======================================================================
MONETARY-DECIMAL-POINT Function Syntax
=======================================================================
MONETARY-DECIMAL-POINT
~~~~~~~~~~~~~~~~~~~~~~
=======================================================================
MONETARY-THOUSANDS-SEPARATOR Function Syntax
=======================================================================
MONETARY-THOUSANDS-SEPARATOR
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
=======================================================================
NATIONAL-OF Function Syntax
=======================================================================
NATIONAL-OF(argument-1 [argument-2] )
~~~~~~~~~~~
=======================================================================
NUMERIC-DECIMAL-POINT Function Syntax
=======================================================================
NUMERIC-DECIMAL-POINT
~~~~~~~~~~~~~~~~~~~~~
=======================================================================
NUMERIC-THOUSANDS-SEPARATOR Function Syntax
=======================================================================
NUMERIC-THOUSANDS-SEPARATOR
~~~~~~~~~~~~~~~~~~~~~~~~~~~
=======================================================================
NUMVAL Function Syntax
=======================================================================
NUMVAL(string)
~~~~~~
=======================================================================
NUMVAL-C Function Syntax
=======================================================================
NUMVAL-C (string [, symbol ]
~~~~~~~~
[, LOCALE locale-name-1 ] [, ANYCASE ])
=======================================================================
NUMVAL-F Function Syntax
=======================================================================
NUMVAL-F(char)
~~~~~~~~
=======================================================================
ORD Function Syntax
=======================================================================
ORD(char)
~~~
=======================================================================
ORD-MAX Function Syntax
=======================================================================
ORD-MAX(char-1 [, char-2 ]...)
~~~~~~~
=======================================================================
ORD-MIN Function Syntax
=======================================================================
ORD-MIN(char-1 [, char-2 ]...)
~~~~~~~
=======================================================================
PI Function Syntax
=======================================================================
PI
~~
=======================================================================
PRESENT-VALUE Function Syntax
=======================================================================
PRESENT-VALUE(rate, value-1 [, value-2 ])
~~~~~~~~~~~~~
=======================================================================
RANDOM Function Syntax
=======================================================================
RANDOM[(seed)]
~~~~~~
=======================================================================
RANGE Function Syntax
=======================================================================
RANGE(number-1 [, number-2 ]...)
~~~~~
=======================================================================
REM Function Syntax
=======================================================================
REM(number,divisor)
~~~
=======================================================================
REVERSE Function Syntax
=======================================================================
REVERSE(string)
~~~~~~~
=======================================================================
SECONDS-FROM-FORMATTED-TIME Function Syntax
=======================================================================
SECONDS-FROM-FORMATTED-TIME(format,time)
~~~~~~~~~~~~~~~~~~~~~~~~~~~
=======================================================================
SECONDS-PAST-MIDNIGHT Function Syntax
=======================================================================
SECONDS-PAST-MIDNIGHT
~~~~~~~~~~~~~~~~~~~~~
=======================================================================
SIGN Function Syntax
=======================================================================
SIGN(number)
~~~~
=======================================================================
SIN Function Syntax
=======================================================================
SIN(argument-1)
~~~
=======================================================================
SQRT Function Syntax
=======================================================================
SQRT (number)
~~~~
=======================================================================
STANDARD-COMPARE Function Syntax
=======================================================================
STANDARD-COMPARE(argument-1 argument-2 [ordering-name-1] [argument-4] )
~~~~~~~~~~~~~~~~
=======================================================================
STANDARD-DEVIATION Function Syntax
=======================================================================
STANDARD-DEVIATION(number-1 [, number-2 ]...)
~~~~~~~~~~~~~~~~~~
=======================================================================
STORED-CHAR-LENGTH Function Syntax
=======================================================================
STORED-CHAR-LENGTH(string)
~~~~~~~~~~~~~~~~~~
=======================================================================
SUBSTITUTE Function Syntax
=======================================================================
SUBSTITUTE(string, from-1, to-1 [, from-n, to-n ]...)
~~~~~~~~~~
=======================================================================
SUBSTITUTE-CASE Function Syntax
=======================================================================
SUBSTITUTE-CASE(string, from-1, to-1 [, from-n, to-n ]...)
~~~~~~~~~~~~~~~
=======================================================================
SUM Function Syntax
=======================================================================
SUM(number-1 [, number-2 ]...)
~~~
=======================================================================
TAN Function Syntax
=======================================================================
TAN(argument-1)
~~~
=======================================================================
TEST-DATE-YYYYMMDD Function Syntax
=======================================================================
TEST-DATE-YYYYMMDD (date)
~~~~~~~~~~~~~~~~~~
=======================================================================
TEST-DAY-YYYYDDD Function Syntax
=======================================================================
TEST-DAY-YYYYDDD (date)
~~~~~~~~~~~~~~~~
=======================================================================
TEST-FORMATTED-DATETIME Function Syntax
=======================================================================
TEST-FORMATTED-DATETIME ( argument-1, argument-2 )
~~~~~~~~~~~~~~~~~~~~~~~
=======================================================================
TEST-NUMVAL Function Syntax
=======================================================================
TEST-NUMVAL (string)
~~~~~~~~~~~
=======================================================================
TEST-NUMVAL-C Function Syntax
=======================================================================
TEST-NUMVAL-C (string[,symbol])
~~~~~~~~~~~~~
=======================================================================
TEST-NUMVAL-F Function Syntax
=======================================================================
TEST-NUMVAL-F (string)
~~~~~~~~~~~~~
=======================================================================
TRIM Function Syntax
=======================================================================
TRIM(string [, LEADING|TRAILING ])
~~~~ ~~~~~~~ ~~~~~~~~
=======================================================================
UPPER-CASE Function Syntax
=======================================================================
UPPER-CASE(string)
~~~~~~~~~~
=======================================================================
VARIANCE Function Syntax
=======================================================================
VARIANCE(number-1 [, number-2 ]...)
~~~~~~~~
=======================================================================
WHEN-COMPILED Function Syntax
=======================================================================
WHEN-COMPILED
~~~~~~~~~~~~~
=======================================================================
YEAR-TO-YYYY Function Syntax
=======================================================================
YEAR-TO-YYYY(yy [, yy-cutoff [, yy-execution-time ]])
~~~~~~~~~~~~