### 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 |