16.20 - Migration Issues - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

prodname
ODBC Driver for Teradata
vrm_release
16.20
created_date
August 2020
category
User Guide
featnum
B035-2526-108K

Applications that migrate to an ODBC Driver with Native LOB Support may behave differently than before the migration. This might be related to the use of LOBs.

There can be two reasons for the difference in behavior:
  • The application relies on the ODBC feature that allows an application to query for all available types and uses that information to generate SQL
  • The application uses the ODBC types SQL_LONGVARBINARY and SQL_LONGVARCHAR

Applications that query for all types will now receive information about two data types (BLOB and CLOB) which can cause problems in some cases. See SQLGetTypeInfo.

Applications that use SQL_LONGVARBINARY and SQL_LONGVARCHAR may behave differently since these types are now mapped differently.

If application behavior has changed, consider disabling the Native LOB functionality by setting UseNativeLOBSupport=No.

The option to set Native LOB Support is deprecated. For more information, see Deprecated SQL Transformations