Feature Representation

Features read from an Informix database consist of a series of attribute values. They have no geometry. The attribute names are as defined in the DEF line if the first form of the DEF line was used. If the second form of the DEF line was used, then the attribute names are as they are returned by the query, and as such may have their original table names as qualifiers. The feature type of each Informix feature is as defined on its DEF line.

Features written to the database have the destination table as their feature type, and attributes as defined on the DEF line.

DATE and DATETIME Fields

When a DATE field is read by the Informix reader, two attributes are set in the FME feature. The first attribute has the name of the database column, and its value is of the form YYYYMMDD. This is compatible with all other FME date and time values.

The second attribute has a suffix of .full and is of the form YYYYMMDDHHMMSS. It specifies the date and the time, with the time portion specified using the 24-hour clock.

For example, if a date field called UPDATE_DATE is read, the following attributes will be set in the retrieved FME feature:

UPDATE_DATE =’19980820’ 
UPDATE_DATE.full=’19980820000000’

The Informix writer looks for both attributes when a DATE or DATETIME column is being output. Either may be specified. If both attributes are specified, then the value specified in the <name>.full attribute takes precedence.