Teradata ODBC Specific Comparison Operators (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 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