ODBC API Conformance - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-25
dita:mapPath
fxv1527114222338.ditamap
dita:ditavalPath
Audience_PDF_product_legacy_odbc_include.ditaval
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities
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.