VARCHAR Constraints - Access Module

Teradata Tools and Utilities Access Module Reference

Product
Access Module
Release Number
16.10
Published
July 2017
Language
English (United States)
Last Update
2019-03-27
dita:mapPath
amk1499705096540.ditamap
dita:ditavalPath
amk1499705096540.ditaval
dita:id
B035-2425
lifecycle
previous
Product Category
Teradata Tools and Utilities
By default, the Teradata Access Module for OLE DB uses the maximum VARCHAR data type specification supported by Teradata Database: 64000 B. Data types like SQL Server “text” can return a length that greatly exceeds the 64000 B maximum. When selecting columns of this type, remember the following:
  • Rows with a total length exceeding the maximum are not loaded; long string data are not truncated.
  • After the Teradata Access Module for OLE DB returns all rows it can successfully return, in response to the next request for rows the access module returns an error message indicating the number of rows not loaded. This usually causes the job to fail.

When truncating long string data, use an SQL command to create the rowset to be loaded. When using the SQL command, specify the SUBSTRING function in the select-item-list of the SELECT command to truncate the data before it reaches the Teradata Access Module for OLE DB.