Table of Contents


Ispirer Website Ispirer Capabilities - Informix Migration Free Trial

Informix - SQL Functions Mapping to Other Databases

Numeric Functions Mapping

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

String Functions Mapping

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