Starting with Teradata Database V2R6.2, support was added for improved metadata for parameters used in SQL requests and for columns in result sets. The improved metadata is collectively known as Extended Statement Information. ODBC Driver for Teradata uses the extended statement information if it is supported by Teradata Database, but the use of extended statement information in ODBC can also be explicitly disabled through a configuration option (Enable Extended Statement Information check box in the DSN setup dialog, and EnableExtendedStmtInfo in the odbc.ini file).
- Discover that SQLDescribeParam is supported and start using it
- Receive SQL_UNKNOWN_TYPE when calling SQLGetDescField for some parameters in certain SQL expressions where the database cannot determine the type
- Find that some descriptor fields that were not set are now set or have different values
- Discover that information about datetime types and intervals is now more precise
The different values of some of the descriptor fields in ODBC Driver for Teradata when extended statement information is available might affect applications that rely on the old behavior. If necessary, such applications can obtain the old behavior by disabling extended statement information in the ODBC configuration.
The following sections describe differences in the values of descriptor fields when extended statement information is available.