16.20 - Changes and Additions - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

prodname
ODBC Driver for Teradata
vrm_release
16.20
created_date
August 2020
category
User Guide
featnum
B035-2526-108K

The following changes were made to this book in support of the current release.

Date Release Description
August 2020 16.20.11 OutputAsResultSet functionality has been restored, and is no longer deprecated.
October 2018 16.20.11
  • Configuration for Windows:
    • Teradata ODBC Driver Options: Updated the dialog box and added the Enable Client Side UDF Upload and UDF Upload Path fields to the table's new UDF Upload section.
    • Teradata ODBC Driver Advanced Options:
      • Updated AccountString to specify AccountStr.
      • Updated the Max Single LOB Bytes default value to 4000.
      • Updated the Max Total LOB Bytes Per Row value to 65336.
  • Configuration for Apple OS X:
    • Teradata ODBC Driver Options: Updated the dialog box and added the Enable Client Side UDF Upload and UDF Upload Path fields.
    • Teradata ODBC Driver Advanced Options:
      • Updated AccountString to specify AccountStr.
      • Updated the Max Single LOB Bytes default value to 4000.
      • Updated the Max Total LOB Bytes Per Row value to 65336.
  • Configuration of odbc.ini in UNIX/Linux and Apple OS X:
    • Teradata DSN Options: Updated AccountString information.
    • Added EnableUDFUpload for the new Enable UDF Source Upload from Client field.
    • Added UDFUploadPath for the new Source Root Directory field.
  • ODBC Application Development, LOB Retrieval Modes:
    • Updated the Max Single LOB Bytes default value to 4000.
    • Updated the Max Total LOB Bytes Per Row value to 65336.
April 2018 16.20.06
  • Overview:
    • Key Changes in Product Behavior: Removed the HPUX reference.
    • ODBC Integrated Directories: Updated the paragraph describing installation options.
    • Linux/UNIX and Apple OS X Systems: Updated tdodbc instances to tdbc1620.
    • ODBC Integrated Directories: Updated paragraph describing installation options and capitalize the ODBC instances in the file paths in the table (for example, ODBC_32/).
  • Configuration for UNIX/Linux Systems:
    • ODBC Directories: Updated the ErrorMessage directory reference to specify ErrorMessages.
    • Coexistence of Different Version Drivers on the Same Machine: Updated the .env file location path to specify <prefix>/teradata/client/16.20/etc and updated the version references in the bash.env and csh.env files to 1620.
  • Configuration for Windows:
    • ODBC Driver Setup Parameters: Updated the table's Mechanism row to remove SPNEGO as it is no longer supported; and added JSON Web Token (JWT) as a new mechanism.
    • Teradata ODBC Driver Advanced Options: Updated State Check Level default value and removed the Note indicating feature deprecation.
    • Teradata ODBC Driver Options: Updated the Driver Options figure.
    • Windows ODBC Driver Directories: Updated the following directory and directory options and added a directory:
      • tdodbcdsn is now tdodbcdsn.vbs
      • libcrypto-1_1-x64.dll is now libcrypto-1_1-x64.dll or libcrypto-1_1.dll
      • sbicudt53_64.dll is now sbicudt53_64.dll or sbicudt53_32.dll
      • sbicuin53_64.dll is now sbicuin53_64.dll or sbicuin53_32.dll
      • sbicuuc53_64.dll is now sbicuuc53_64.dll or sbicuuc53_32.dll
      • tdataodbc_sb64.dll is now tdataodbc_sb64.dll or tdataodbc_sb32.dll
      • TeradataODBC64.man or TeradataODBC32.man was added
  • Configuration for Apple OS X:
    • Configuring a DSN Using ODBC Administrator Tool: Updated the table's Mechanism row to add JSON Web Token (JWT) as a new mechanism.
    • Teradata ODBC Driver Options: Updated the Teradata ODBC Driver Options figure.
  • ODBC Application Development:
    • UNIX OS Application Development: Removed SUSE Linux 390 as a supported operating system.
    • Scalar Functions: Updated the section with new content.
    • Teradata Database Connect: Updated Mechanism row to include JWT as a supported mechanism
  • Network Security:
    • Authentication Mechanisms: Added JSON Web Token.
    • Username and Password Requirements: Deleted the TD0 row as TD2 supersedes it, and added a row for JWT.
  • ODBC Driver for Teradata Application Development:
    • Added a new section titled SET TRANSFORM GROUP FOR TYPE Statement.
  • odbc.ini File Examples:
    • Release-Independent 64-bit odbc.ini File Example: Updated tdata.so to tdataodbc_sb64.so.
    • Release-Independent odbc.ini File for Apple OS X Example: Updated tdata.dylib to tdataodbc_sbu.dylib
  • odbcinst.ini File Examples:
    • Release-Independent 64-bit odbcinst.ini File Example: Updated tdata.so to tdataodbc_sb64.so.
    • Release-Dependent 32-bit odbcinst.ini File Example: Updated tdata.so to tdataodbc_sb32.so.
    • Release-Dependent 64-bit odbcinst.ini File Example: Updated tdata.so to tdataodbc_sb64.so.
  • Deprecated SQL Transformations:
    • Data Source Specification Options Example: Updated tdata.so to tdataodbc_sb64.so.
    • DSN Tracing Options Example: Updated the file example to reflect the SEN driver.
  • New Teradata ODBC Driver Compatibility Reference:
    • Catalog Functions: Added section titled SQLBindParameter and Data Types with Fractional Seconds.
November 2017 16.20.00 Initial release.

This book leverages content from the ODBC Driver for Teradata User Guide (B035-2509) to match the functionality of the new Teradata ODBC Driver 16.20.