Data Types

The DATETIME and DATE data types need special consideration.

DATETIME Considerations using Informix Load Stages
In Informix, a valid DATETIME format can be either yyyy-mo-dd hh:mi:ss.ff or any contiguous subset of this string, for example, mo-dd hh. Any column defined to contain such a subset would not accept a full ANSI DATETIME.
DATE Considerations using Informix XPS Load Stages
Informix uses the DBDATE or GL_DATE environment variables for interpreting and displaying the string representation of the DATE data type.
Creating the Target Table
If the value of the Load Action property is CREATE, Informix XPS Load creates the table on the target database if it does not already exist.

Parent topic: Informix XPS Load stage