Changes and Additions

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

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

Date and Release Description

October 2018

16.20.11

  • Chapter 3:
    • 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.
  • Chapter 4:
    • 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.
  • Chapter 5:
    • 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.
  • Chapter 6, 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

  • Chapter 1:
    • 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/).
  • Chapter 2:
    • 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.
  • Chapter 3:
    • 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
  • Chapter 4:
    • 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.
  • Chapter 6:
    • 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
  • Chapter 7:
    • Authentication Mechanisms: Added JSON Web Token.
    • Username and Password Requirements: Deleted the TD0 row as TD2 supersedes it, and added a row for JWT.
  • Chapter 8:
    • Added a new section titled SET TRANSFORM GROUP FOR TYPE Statement.
  • Appendix A:
    • 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
  • Appendix B:
    • 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.
  • Appendix D:
    • 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.
  • Appendix H:
    • 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.