ODBC Scalar Functions Outside Escape Sequences (deprecated in 14.10)

ODBC Driver for Teradata® User Guide

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

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;