Changes and Additions - ODBC Driver for Teradata

• 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.

• 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.

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.