ODBC Scalar Functions Outside Escape Sequences (deprecated in 14.10) - 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 ODBC Driver for Teradata support for ODBC scalar functions outside escape sequences has been deprecated. This is a Teradata specific extension to the ODBC standard and its use is deprecated for compatibility reasons. Support will be discontinued in order to facilitate reuse of SQL between products. Support for this feature will be unavailable in ODBC Driver for Teradata 16.00.

ODBC scalar functions should always be used within escape sequences. For example:

SELECT {fn DAYOFWEEK(delivery_date)} FROM order_table;