ADABAS provides an extensive range of built-in functions, most of which can be employed in the SELECT statements for qualification or data formatting.
Basic arithmetical operations
+, -, *, /, DIV, MOD
Operations on sets of values
COUNT, MAX, MIN, SUM, AVG, STDDEV, VARIANCE
Arithmetical functions
TRUNC, ROUND, FIXED, CEIL, FLOOR, SIGN, ABS,
POWER, SQRT, LENGTH, INDEX, COS, SIN, TAN, COT,
COSH, SINH, TANH, ACOS, ASIN, ATAN, ATAN2,
RADIANS, DEGREES, EXP, LN, LOG, PI
Functions on character strings
SUBSTR, || (concatenation), & (concatenation),
LFILL, RFILL, TRIM, LTRIM, RTRIM, EXPAND, UPPER,
LOWER, LPAD, RPAD, MAPCHAR, INITCAP, REPLACE,
TRANSLATE, ALPHA, ASCII, EBCDIC, SOUNDEX
Date functions
ADDDATE, SUBDATE, DATEDIFF, DAYOFWEEK, DAYOFMONTH,
WEEKOFYEAR, DAYOFYEAR, MAKEDATE, YEAR, MONTH, DAY,
TIMESTAMP, DAYNAME, MONTHNAME
Time functions
ADDTIME, SUBTIME, TIMEDIFF, MAKETIME, HOUR,
MINUTE, SECOND, TIME, MICROSECOND
Generic functions
VALUE, GREATEST, DECODE, LEAST
Conversion functions
NUM, CHR, HEX, CHAR
With these built-in functions, extensive and complex calculations or evaluations can be performed very easily on the ADABAS database. This saves a major part of conventional application programming.