Supported data types

Informix® Warehouse Accelerator supports specific data types.

The following data types are supported:

  • BIGINT
  • BIGSERIAL
  • CHAR
  • CHARACTER
  • CHARACTER VARYING
  • DATE
  • DATETIME HOUR TO HOUR
  • DATETIME HOUR TO MINUTE
  • DATETIME HOUR TO SECOND
  • DATETIME YEAR TO DAY
  • DATETIME YEAR TO FRACTION(x)
  • DATETIME YEAR TO HOUR
  • DATETIME YEAR TO MINUTE
  • DATETIME YEAR TO MONTH
  • DATETIME YEAR TO SECOND
  • DATETIME YEAR TO YEAR
  • DECIMAL(p,s), with p <= 31.
  • DOUBLE PRECISION
  • FLOAT
  • INT
  • INT8
  • INTEGER
  • LVARCHAR
  • MONEY
  • NUMERIC(p,s), with p <= 31.
  • REAL
  • SERIAL
  • SERIAL8
  • SMALLFLOAT
  • SMALLINT
  • VARCHAR

Restrictions

  • Arithmetic operations that include values of different DATE or DATETIME type variants that are not supported by Informix Warehouse Accelerator are automatically run by Informix, unless the fallback option is set to off. For example, Informix supports subtracting a DATETIME YEAR TO MINUTE value from a DATETIME YEAR TO MONTH value, but Informix Warehouse Accelerator does not.