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

ODBC Driver for Teradata User Guide

ODBC Driver for Teradata
User Guide

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