DSN Option for Enable Legacy Parser - 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 EnableLegacyParser DSN option, which enables switching between the legacy parser and the new parser, has been deprecated.

The Legacy ODBC SQL parser in the driver understands more of the structure of SQL than it needs to in order to perform the transformations required by the ODBC specification. This means that if there are changes anywhere in the subset of SQL that the parser recognizes, then the parser also has to be changed. Another consequence is that the parser grows unnecessarily, which impacts performance both in terms of memory for parse tables and time for syntax analysis.

For every addition or update to SQL syntax in the database, the legacy parser must also be updated. This activity consumes a considerable amount of time in every release.

The legacy parser is capped to ODBC Driver for Teradata 15.00, and no 15.10 features were supported. So it is strongly advised to retain the default value for this option when using the ODBC driver against DBS 15.10 and later.

Support for the capped legacy parser will be maintained for a period, but will be unavailable in the ODBC Driver for Teradata 18.00.