Informix

Supported Versions

  • 12.10

Drivers

URL format jdbc:informix-sqli://host:port/database:informixserver=dev
Download Maven Central coordinates: com.ibm.informix:jdbc:4.10.10.0
Supported versions 4.10.10.0 and later
Default Java class com.informix.jdbc.IfxDriver

SQL Script Syntax

Compatibility

  • Both Informix SQL and SPL statements can be used unchanged in a MigrateDB migration.

Example

/* Single line comment */
CREATE SEQUENCE seq_2
   INCREMENT BY 1 START WITH 1
   MAXVALUE 30 MINVALUE 0
   NOCYCLE CACHE 10 ORDER;

CREATE TABLE tab1 (col1 int, col2 int);
INSERT INTO tab1 VALUES (0, 0);

INSERT INTO tab1 (col1, col2) VALUES (seq_2.NEXTVAL, seq_2.NEXTVAL);

/*
Multi-line
comment
*/
-- SPL
CREATE PROCEDURE raise_prices ( per_cent INT, selected_unit CHAR )
	UPDATE stock SET unit_price = unit_price + (unit_price * (per_cent/100) )
	where unit=selected_unit;
END PROCEDURE;

CREATE FUNCTION square ( num INT )
   RETURNING INT;
   return (num * num);
END FUNCTION
   DOCUMENT "USAGE: Update a price by a percentage",
         "Enter an integer percentage from 1 - 100",
         "and a part id number";

-- Placeholder
INSERT INTO ${tableName} (col1, col2) VALUES (2, 3);

Limitations

  • No Support for migratedb.schemas due to Informix limitations.
  • No Support for DDL transactions due to Informix limitations.

H2 ➡️