17.10 - Attributes Missing - Access Module

Teradata® Tools and Utilities Access Module Reference

Product
Access Module
Release Number
17.10
Published
October 2021
Language
English (United States)
Last Update
2021-11-02
dita:mapPath
uur1608578381725.ditamap
dita:ditavalPath
obe1474387269547.ditaval

Problem: Some table attributes might not be propagated from the source table to the destination table because only OLE DB-supported attributes are handled. The Teradata Access Module for OLE DB lets you connect a Teradata utilities to arbitrary OLE DB providers. The focus is on loading from an OLE DB-supported data source to a database and exporting from a database to an OLE DB-supported data source. As such, only OLE DB-supported attributes are handled.

Solution: To preserve Teradata-specific table attributes (such as the display format information for date and time that can be attached to columns), edit the sample script created by Teradata OleLoad to include the desired formatting for the date and time columns. The default date and time formats in the sample load scripts are YYYY-MM-DD and HH:MI:SS. These come from string entries number 78 and 40 in the resource-only .dll, OLEDB_AXSMODenu.dll.