ODBC API Conformance

ODBC Driver for Teradata® User Guide

brand
Teradata Tools and Utilities
prodname
ODBC Driver for Teradata
vrm_release
16.20
category
User Guide
featnum
B035-2526-108K
For the following functions, the new driver adheres to a different level of ODBC API conformance than the old driver:
  • SQLExecute and SQLExecDirect, when no rows are affected by the statement.

    When a statement affects 0 rows, the old driver returns SQL_SUCCESS. The new driver returns SQL_SUCCESS when using ODBC 2.x, and returns SQL_NO_DATA when using ODBC 3.x.

    For more information, see "SQL_NO_DATA" in the ODBC Programmers' Reference: https://docs.microsoft.com/en-us/sql/odbc/reference/develop-app/sql-no-data.

  • SQLPrepare, SQLExecute, and SQLExecDirect, when an empty statement is passed in.

    When an empty SQL statement is passed into SQLPrepare, SQLExecute, or SQLExecDirect, the old driver returns SQL_SUCCESS. The new driver returns SQL_ERROR with SQLState 42000.