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