When you create an archive entity for a Informix source database, adhere to the following guidelines:
The interim table name must be in uppercase characters.
In the default columns of the entity interim table, enter a double quotation mark in the SELECT clause field for the STATS_DATE and ORG_ID columns. Do not leave these fields blank.
In the table insert and delete statements, the interim table name and column names must be surrounded by double quotation marks. The entity table name and column names should not be in double quotation marks.
Delete statements should not contain a table alias name with the primary key. For example: Change (A. "integer") to (integer).