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 |