Some of the restrictions for using ODBC Driver for Teradata include:
The SET SESSION DateForm command is not allowed in a multi-statement request
The time zone value for TIME WITH TIME ZONE and TIMESTAMP WITH TIME ZONE must be converted
to an ODBC C character type. The standard ODBC C time and timestamp types do not have
a time zone component
ODBC Driver for Teradata inadvertently allows for data conversions from SQL_TYPE_DATE
or SQL_TYPE_TIME to SQL_C_FLOAT or SQL_C_DOUBLE when ODBC Driver for Teradata date
and time formats are set to Integer. These conversions are not valid, however, as stated in the ODBC specification and
any requests for such conversions should return SQL_ERROR with SQLSTATE 07006.
(Windows) Since the ODBC driver does not support PMPC commands, asynchronous niching
(priority of execution) of a query is not supported, but self-niching queries are
supported.
The Teradata TIME type allows fractional seconds, but there is limited support for
fractional seconds of TIME in standard ODBC. As an extension to standard ODBC, the
Teradata ODBC Driver preserves fractional seconds in conversions between character
ODBC C data types and SQL_TYPE_TIME.