Ispirer Migration Knowledge Base

Informix - SQL Functions Mapping to Other Databases

Informix	Oracle	SQL Server	IBM DB2	MySQL	PostgreSQL	Sybase ASE	Sybase ASA
ABS	ABS	ABS	ABS	ABS	ABS	ABS	ABS
ACOS	ACOS	ACOS	ACOS	ACOS	ACOS	ACOS	ACOS
ASIN	ASIN	ASIN	ASIN	ASIN	ASIN	ASIN	ASIN
ATAN	ATAN	ATAN	ATAN	ATAN	ATAN	ATAN	ATAN
ATAN2	ATAN2	ATN2	ATAN2	ATAN2	ATAN2	ATN2	ATAN2
COS	COS	COS	COS	COS	COS	COS	COS
EXP	EXP	EXP	EXP	EXP	EXP	EXP	EXP
LOGN	LN	LOG	LN	LN	LN	LOG	LOG
LOG10	LOG	LOG10	LOG10	LOG10	LOG	LOG10	LOG10
MOD	MOD		MOD	MOD	MOD		MOD
POW	POWER	POWER	POWER	POWER	POWER	POWER	POWER
ROOT
ROUND	ROUND (number)	ROUND	ROUND	ROUND	ROUND	ROUND	ROUND
SIN	SIN	SIN	SIN	SIN	SIN	SIN	SIN
SQRT	SQRT	SQRT	SQRT	SQRT	SQRT	SQRT	SQRT
TAN	TAN	TAN	TAN	TAN	TAN	TAN	TAN
TRUNC	TRUNC (number)		TRUNCATE	TRUNCATE	TRUNC		TRUNCNUM

Informix	Oracle	SQL Server	IBM DB2	MySQL	PostgreSQL	Sybase ASE	Sybase ASA
CHAR_LENGTH	LENGTH	LEN	LENGTH	CHAR_LENGTH	LENGTH	LEN	LENGTH
INITCAP	INITCAP				INITCAP
LENGTH	LENGTH	LEN	LENGTH	CHAR_LENGTH	LENGTH	LEN	LENGTH
LOWER	LOWER	LOWER	LCASE	LOWER	LOWER	LOWER	LOWER
LPAD	LPAD			LPAD	LPAD
OCTET_LENGTH	LENGTH	LEN	LENGTH	CHAR_LENGTH	LENGTH	LEN	LENGTH
REPLACE	REPLACE	REPLACE	REPLACE	REPLACE	REPLACE	STR_REPLACE	REPLACE
RPAD	RPAD			RPAD	RPAD
SUBSTR	SUBSTR	SUBSTRING	SUBSTR	SUBSTR	SUBSTR	SUBSTRING	SUBSTRING
TRIM	TRIM		STRIP	TRIM	BTRIM		TRIM
UPPER	UPPER	UPPER	UCASE	UPPER	UPPER	UPPER	UCASE