IBM DB2 Functions [Ispirer Migration Knowledge Base]

User Documentation Ispirer Capabilities - DB2 Migration Pricing

IBM DB2 Functions

SQL Functions Mapping to Other Databases
Numeric Functions
- ABS
- ACOS
- ASIN
- ATAN
- ATANH
- ATAN2
- CEILING
- COS
- COSH
- COT
- DEGREES
- EXP
- FLOOR
- LN
- LOG
- LOG10
- MOD
- MULTIPLY_ALT
- POWER
- RADIANS
- RAND
- ROUND
- SIGN
- SIN
- SINH
- SQRT
- TAN
- TANH
- TRUNCATE
String Functions
- ASCII
- CHARACTER_LENGTH
- CHR
- CONCAT
- DIFFERENCE
- INSERT
- LENGTH
- LCASE
- LEFT
- LOCATE
- LTRIM
- OCTET_LENGTH
- POSITION
- POSSTR
- REPEAT
- REPLACE
- RIGHT
- RTRIM
- SOUNDEX
- SPACE
- STRIP
- SUBSTR
- SUBSTRING
- TRANSLATE
- TRIM
- UCASE
Date and Time Functions
- DAY
- DAYNAME
- DAYOFWEEK
- DAYOFWEEK_ISO
- DAYOFYEAR
- DAYS
- HOUR
- JULIAN_DAY
- MICROSECOND
- MIDNIGHT_SECONDS
- MINUTE
- MONTH
- MONTHNAME
- QUARTER
- SECOND
- TIMESTAMP_FORMAT
- TIMESTAMP_ISO
- TIMESTAMPDIFF
- TO_CHAR
- TO_DATE
- VARCHAR_FORMAT
- WEEK
- WEEK_ISO
- YEAR
Analitic and Aggregate Functions
- AVG
- CORRELATION
- COUNT
- COUNT_BIG
- COVARIANCE
- GROUPING
- MAX
- MIN
- REGR_AVGX
- REGR_AVGY
- REGR_COUNT
- REGR_INTERCEPT or REGR_ICPT
- REGR_R2
- REGR_SLOPE
- REGR_SXX
- REGR_SXY
- REGR_SYY
- STDDEV
- SUM
- VARIANCE
Conversion Functions
- BIGINT
- BLOB
- CHAR
- CLOB
- DATE
- DBCLOB
- DECIMAL
- DECRYPT_BIN
- DECRYPT_CHAR
- DIGITS
- DOUBLE
- ENCRYPT
- FLOAT
- GRAPHIC
- HEX
- REC2XML
- INTEGER
- LONG_VARCHAR
- LONG_VARGRAPHIC
- REAL
- SMALLINT
- TIME
- TIMESTAMP
- VARCHAR
- VARGRAPHIC
XML Functions
- XMLAGG
- XMLATTRIBUTES
- XMLCOMMENT
- XMLCONCAT
- XMLDOCUMENT
- XMLELEMENT
- XMLFOREST
- XMLNAMESPACES
- XMLPARSE
- XMLPI
- XMLQUERY
- XMLSERIALIZE
- XMLTABLE
- XMLTEXT
- XMLVALIDATE
- XMLXSROBJECTID
Environment and System Functions
- COALESCE
- DEREF
- EVENT_MON_STATE
- GENERATE_UNIQUE
- GETHINT
- IDENTITY_VAL_LOCAL
- NULLIF
- RAISE_ERROR
- TABLE_NAME
- TABLE_SCHEMA
- TYPE_ID
- TYPE_NAME
- TYPE_SCHEMA
- VALUE
Other Functions