Function list
A built-in function is a function that is supplied with DB2 for i5/OS. Functions
are classified as column functions or scalar functions. The argument of a
column function is a set of values. An argument of a scalar function is a
single value.
AVG
COUNT
COUNT_BIG
GROUPING
MAX
MIN
STDDEV or STDDEV_POP
STDDEV_SAMP
SUM
VAR or VARIANCE or VAR_POP
VAR_SAMP or VARIANCE_SAMP
BIGINT
BINARY
BLOB
CHAR
CLOB
DATE
DBCLOB
DECIMAL or DEC
DECFLOAT
DOUBLE_PRECISION or DOUBLE
FLOAT
GRAPHIC
INTEGER or INT
REAL
ROWID
SMALLINT
TIME
TIMESTAMP
TIMESTAMP_ISO
VARBINARY
VARCHAR
VARGRAPHIC
ZONED
DLCOMMENT
DLLINKTYPE
DLURLCOMPLETE
DLURLPATH
DLURLPATHONLY
DLURLSCHEME
DLURLSERVER
DLVALUE
ADD_MONTHS
CURDATE
CURTIME
DAY
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFWEEK_ISO
DAYOFYEAR
DAYS
EXTRACT
HOUR
JULIAN_DAY
LAST_DAY
MICROSECOND
MIDNIGHT_SECONDS
MINUTE
MONTH
MONTHNAME
MONTHS_BETWEEN
NEXT_DAY
NOW
QUARTER
ROUND_TIMESTAMP
SECOND
TIMESTAMP_FORMAT
TIMESTAMPDIFF
TRUNCATE_TIMESTAMP
VARCHAR_FORMAT
WEEK
WEEK_ISO
YEAR
DATAPARTITIONNAME
DATAPARTITIONNUM
DBPARTITIONNAME
DBPARTITIONNUM
HASH
COALESCE
DATABASE
GENERATE_UNIQUE()
HEX
IDENTITY_VAL_LOCAL
IFNULL
LENGTH
MAX
MIN
NULLIF
RAISE_ERROR
RID
RRN
VALUE
ABS or ABSVAL
ACOS
ANTILOG
ASIN
ATAN
ATANH
ATAN2
CEILING or CEIL
COMPARE_DECFLOAT
COS
COSH
COT
DECFLOAT_SORTKEY
DEGREES
DIGITS
EXP
FLOOR
LN
LOG or LOG10
MOD
MULTIPLY_ALT
NORMALIZE_DECFLOAT
PI
POWER
QUANTIZE
RADIANS
RAND
ROUND
SIGN
SIN
SINH
SQRT
TAN
TANH
TOTALORDER
TRUNCATE
ASCII
BIT_LENGTH
CHARACTER_LENGTH or CHAR_LENGTH
CONCAT
DECRYPT_BINARY
DECRYPT_BIT
DECRYPT_CHAR
DECRYPT_DB
DIFFERENCE
ENCRYPT_RC2
ENCRYPT_AES
ENCRYPT_TDES
GETHINT
INSERT
LAND
LOWER or LCASE
LEFT
LNOT
LOCATE
LOR
LTRIM
OCTET_LENGTH
POSITION or POSSTR
REPEAT
REPLACE
RIGHT
RTRIM
SOUNDEX
SPACE
STRIP
SUBSTRING or SUBSTR
TRANSLATE
TRIM
UCASE or UPPER
XOR
For more detailed information on functions, see Built-in functions in the SQL Reference topic in the
Information Center
.