Ispirer Migration Knowledge Base

IBM DB2 - SQL Functions Mapping to Other Databases

IBM DB2	Oracle	SQL Server	MySQL
ABS	ABS	ABS	ABS
ACOS	ACOS	ACOS	ACOS
ASIN	ASIN	ASIN	ASIN
ATAN	ATAN	ATAN	ATAN
ATANH
ATAN2	ATAN2	ATN2	ATAN2
CEILING	CEIL	CEILING	CEILING
COS	COS	COS	COS
COSH	COSH
COT		COT	COT
DEGREES		DEGREES	DEGREES
EXP	EXP	EXP	EXP
FLOOR	FLOOR	FLOOR	FLOOR
LN	LN	LOG	LN
LOG	LN	LOG	LN
LOG10	LOG	LOG10	LOG10
MOD	MOD		MOD
MULTIPLY_ALT
POWER	POWER	POWER	POWER
RADIANS		RADIANS	RADIANS
RAND		RAND	RAND
ROUND	ROUND (number)	ROUND	ROUND
SIGN	SIGN	SIGN	SIGN
SIN	SIN	SIN	SIN
SINH	SINH
SQRT	SQRT	SQRT	SQRT
TAN	TAN	TAN	TAN
TANH	TANH
TRUNCATE	TRUNC (number)		TRUNCATE

IBM DB2	Oracle	SQL Server	MySQL
ASCII	ASCII	ASCII	ASCII
CHARACTER_LENGTH	LENGTH	LEN	CHAR_LENGTH
CHR	CHR	CHAR	CHAR
CONCAT	CONCAT		CONCAT
DIFFERENCE		DIFFERENCE
INSERT		STUFF	INSERT
LENGTH	LENGTH	LEN	CHAR_LENGTH
LCASE	LOWER	LOWER	LOWER
LEFT		LEFT	LEFT
LOCATE	INSTR	CHARINDEX	INSTR
LTRIM	LTRIM	LTRIM	LTRIM
OCTET_LENGTH	LENGTH	LEN	CHAR_LENGTH
POSITION	INSTR	CHARINDEX	INSTR
POSSTR	INSTR	CHARINDEX	INSTR
REPEAT		REPLICATE
REPLACE	REPLACE	REPLACE	REPLACE
RIGHT		RIGHT	RIGHT
RTRIM	RTRIM	RTRIM	RTRIM
SOUNDEX	SOUNDEX	SOUNDEX	SOUNDEX
SPACE		REPLICATE
STRIP	TRIM		TRIM
SUBSTR	SUBSTR	SUBSTRING	SUBSTR
SUBSTRING	SUBSTR	SUBSTRING	SUBSTR
TRANSLATE	TRANSLATE
TRIM	TRIM		TRIM
UCASE	UPPER	UPPER	UPPER