INTEGER FORMAT ’99:99:99’ Columns
Data Type Restriction
If a table contains a column that has a data type of INTEGER with a format of ‘99:99:99’ (column definition is INTEGER FORMAT ‘99:99:99’), OLE DB Provider for Teradata interprets the data type of this column as DBTYPE_DBTIME.
IRowsetChange is unable to update a rowset that contains a column defined as INTEGER FORMAT ‘99:99:99’. OLE DB Provider for Teradata reports that this column is of type DBTYPE_DBTIME. When one of the methods of IRowsetChange is called, the data for this column is type cast to TIME. The actual data type of the column is INTEGER. This causes the following Teradata error:
[Teradata Database]Invalid operation on an ANSI DateTime or Interval value.