Teradata ODBC Specific Comparison Operators (deprecated in 14.10) - ODBC Driver for Teradata

ODBC Driver for Teradata User Guide

Product
ODBC Driver for Teradata
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

The ODBC Driver for Teradata support for mapping != and ~= comparison operators to the standard SQL operator <> has been deprecated. Queries that use these operators will not be successful using other Teradata client access products and for this reason the Teradata ODBC support of these operators is deprecated. Furthermore, this alternative will be unavailable in ODBC Driver for Teradata 16.00.

It is strongly advised to not use these Teradata ODBC-specific comparison operators, and to change existing SQL scripts to avoid the usage of these operators.

For example:

SELECT p FROM t WHERE p <> 7 instead of SELECT p FROM t WHERE p != 7