Overview - ODBC Driver for Teradata

ODBC Driver for Teradata User Guide

Product
ODBC Driver for Teradata
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-07-11
dita:mapPath
smj1488824663219.ditamap
dita:ditavalPath
Audience_PDF_product_legacy_odbc_include.ditaval
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

The deprecated SQL Transformations described in this appendix only work with the legacy parser until they were completely removed, and with the default new parser these transformations were not supported. Any application using these deprecated transformations needs to enable the legacy parser:

  • To enable the legacy parser through odbc.ini in UNIX/Linux and Apple OS X platforms, refer to the "EnableLegacyParser=[Yes|No]" option in Teradata DSN Options.
  • To enable the legacy parser through ODBC Administrator in the Windows platform, refer to the description of the "Enable Legacy Parser" check box in Teradata ODBC Driver Options.
  • To enable the legacy parser through ODBC Administrator in the Apple OS X platform, refer to the description of the "Enable Legacy Parser" check box in Configuring a DSN Using ODBC Administrator Tool.

The Teradata ODBC driver contains an SQL parser that replaces ODBC escape sequences in the SQL text with their corresponding Teradata SQL equivalents. Teradata ODBC 15.10 includes a new parser, which is smaller, better performing, and more closely integrated with the driver.

The original parser in the ODBC driver performed some non-standard transformation of the SQL text in order to work around shortcomings both in early applications and in the database at the time. These legacy transformations are no longer needed, and in some cases conflict with the evolution of standard SQL, standard ODBC, and the Teradata database. Some of the transformations have already been deprecated in release 15.0 and older versions of the ODBC Driver for Teradata.

The following sections describe the deprecated transformations which will only work with the legacy parser as mentioned above.