Feature Representation

Features read from a DB2 database consist of a series of attribute values. These features have no geometry.

The attribute names are as defined in the User Attributes.

Features written to the database have the destination table as their feature type.

DATE, TIME, and DATETIME Fields

When a DATE, TIME or TIMESTAMP field is read by the DB2 reader, two attributes are set on the FME feature. The first attribute has the name of the table column, and its value is of the form YYYYMMDD or HHMMSS.

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 on the retrieved FME feature:

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

The DB2 writer looks for both attributes when a date or datetime column is being written. Either may be specified. If both attributes are specified, then the value specified in UPDATE_DATE.full is used to populate the DATE or DATETIME portion of the date.