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.