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 aDATE,TIMEorTIMESTAMPfield 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 formYYYYMMDDorHHMMSS.
The second attribute has a suffix of.fulland is of the formYYYYMMDDHHMMSS. It specifies the date and the time, with the time portion specified using the 24-hour clock.
For example, if a date field calledUPDATE_DATEis 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日期or日期timecolumn is being written. Either may be specified. If both attributes are specified, then the value specified inUPDATE_DATE.fullis used to populate theDATEorDATETIMEportion of the date.