15.10 - ODBC Driver for Teradata User Guide - ODBC Driver for Teradata

Product: ODBC Driver for Teradata
Release Number: 15.10
Language: English (United States)
Last Update: 2018-10-07

Preface
Audience
Supported Releases
Prerequisites
Changes to This Book
Related Documentation
Learning Examples
Product Safety Information
Chapter 1 Overview
New Features
Determining the Current Version of ODBC Driver for Teradata
Determining the Current Version of ODBC Driver for Teradata
Linux/UNIX and Apple OS X Systems
Certification and Release Information
UNIX and Linux Information
Teradata Tools and Utilities Directory Layout
Changes to Runtime Environment Variable Settings
System Library and Driver Directories
ODBC Driver Library
ODBC Integrated Directories
ODBC Legacy Migration
Apple OS X Information
Chapter 2 Configuration for UNIX/Linux Systems
ODBC Directories
Verifying the TCP/IP Connection
Configuring a UNIX System
Setting Additional Environment Variables (optional)
Setting LANG
Configuring DSN in odbc.ini
Chapter 3 Configuration for Windows
Windows ODBC Driver Directories
Configuring a Data Source
Coexistence of 32-Bit and 64-Bit Drivers on the Same Machine
ODBC Data Source Administrator
Obtaining Dialog Box Information
ODBC Driver Setup Parameters
Teradata ODBC Driver Options
Teradata ODBC Driver Advanced Options
Reconfiguring a Data Source
Modifying a Data Source
Deleting a Data Source
Resolving a Data Source Name
Cop Discovery
Session Character Sets and Translation DLLs
Working with DSNs
DSN Tracing
DSN Migration
Backward DSN Migration
ODBC Directories
Chapter 1 Configuration for Apple OS X
ODBC Driver Is Universal Binary
ODBC Driver Directories
ODBC Driver Manager
odbc.ini File
Configuring a DSN Using ODBC Administrator Tool
Configuring a DSN Manually in odbc.ini
Verifying Connection to the Teradata Database
Chapter 5 Configuration of odbc.ini in UNIX/Linux and Apple OS X
ODBC.INI Structure
ODBC Options Section
ODBC Data Sources Section
Data Source Specification Section
ODBC Administration
Modifying the odbc.ini File
Adding a Data Source
Setting ODBCINI
Teradata DSN Options
DSN Tracing Attributes
Chapter 2 ODBC Application Development
ODBC Connection APIs
ODBC Connection Functions and Dialog
SQLConnect
Teradata Database Connect
SQLDriverConnect
SQLBrowseConnect
Chapter 7 Network Security
Password Encryption
Single Sign-On (Windows)
Enabling SSO
SSO Usage
SSO Error Messages
Data Encryption
Connection Level
Statement Level
Backward Compatibility
Gateway Dependency
Performance Considerations
Extensible Authentication, Authorization, and Encryption
Extensible Authentication, Authorization, and Encryption
Authorization
Confidentiality
Integrity
Authentication Mechanisms
Determination of Authentication Mechanism
Configuring Authentication Mechanisms
Connecting to Teradata Database
Username and Password Requirements
Enhancing Security
Constraints
Constraints
Connection Pooling (Windows and Apple OS X)
TDGSS Support for UTF-16
Teradata Wallet
Password Expiration and Teradata Wallet
Chapter 8 ODBC Driver for Teradata Application Development
Teradata Extensions to the ODBC Standard
Connection Attributes
Statement Attributes
SQL Column Attributes
SQL Descriptor Fields
SQLGetTypeInfo
SQLColumns
SQLProcedureColumns
Teradata ODBC Driver SQL Types
Connection Pooling (Windows and Apple OS X)
Pooling Advantage
Driver Manager
Using Connection Pools
Stored Procedures
Stored Procedure Creation from ODBC
Checking for Stored Procedure Support
Print and SPL Options
SPL Compilation Errors and Warnings
Structure of Error and Warning Messages
Executing Stored Procedures from ODBC
Rules for Input and Output Arguments
Stored Procedures Dynamic Result Sets
External Stored Procedures
Auto-Generated Key Retrieval
SQL Descriptor Fields
SQL_DESC_UNSIGNED is set regardless of FORMAT
SQL_DESC_BASE_COLUMN_NAME when there is an alias
SQL_DESC_CASE_SENSITIVE
SQL_DESC_TD_UDT_INDICATOR
SQL_DESC_TD_UDT_NAME
International Character Set Support
International Character Set Support
ODBC C Character Data Types
ODBC SQL Character Data Types
Conversion and Error Handling
ANSI ODBC Applications
Unicode ODBC Applications
Application Considerations
User-Defined Session Character Set Support
Translation DLLs
Application Code Page
UTF-8 Pass Through Functionality
Restrictions
Atomic UPSERT
Syntax
ANSI Date and Time Restrictions
ANSI DateTime Feature
Period Data Types
Availability of Period Data Types
Retrieving Period Data
Using Period Parameters
Period Literals
Geospatial Types
Number Data Types
SQLGetTypeInfo
Retrieving Number Data
Using Number Parameters
Array Data Types
XML Data Type
SQLGetTypeInfo
XML Data Type Values and Conversions
JSON Integration
SQLGetTypeInfo
NoPI Tables
Trusted Sessions
Restrictions
Multi-Statement SQL Requests
Teradata String Constants
Teradata Column Limitation
WITH Clause
Asynchronous Operation
ANSI Migration Issues
ANSI Migration Issues
Data Truncation
Duplicate Rows
Updatable Cursors
Case Sensitivity
Configuration Characteristics
Configuration Characteristics
SQL Considerations
SQL Considerations
ANSI Comments in SQL Requests
DSN Settings for Third-party Applications
Appendix A ODBC Legacy Migration
Migration Scenarios
No Migration
Minimum Migration Scenario
Complete Migration Scenario
ODBC and ODBCINI Migration
Appendix B odbc.ini File Examples
Release-Independent 32-bit odbc.ini File Example
Release-Independent 64-bit odbc.ini File Example
Release-Independent 64-bit odbc.ini File Example
Appendix C odbcinst.ini File Examples
Release-Independent 32-bit odbcinst.ini File Example
Release-Independent 64-bit odbcinst.ini File Example
Appendix D ODBC Options Examples
ODBC Options Section
ODBC Options: IBM AIX, Linux, HP-UX Itanium, Solaris
ODBC Options: HP-UX RISC
ODBC Options: Apple OS X
Data Source Specification Options Example
DSN Tracing Options Example
Appendix E Deprecated Features
DSN option to bypass State Check Level
DSN options to disable prepare of statements
DSN Option for Application Catalog Database
DSN option to DisableAsync
Storing passwords in the DSN
DSN Option for Native Large Object Support
DSN Option to Return Output Parameters as ResultSet
ClientKanjiFormat (UNIX and Linux systems only)
DSN Option for RunInQuietMode
DSN Option for Integer Time
Redisplay Reconnect Wait DSN Option
DSN Option for Enable Legacy Parser
Appendix F Deprecated SQL Transformations
Pseudo Type Mappings
Standard Type Mappings
IN-List Expansion
ODBC-Style Named Indexes (deprecated in 15.00)
CALL to EXEC Conversion (deprecated in 14.10)
Teradata ODBC Specific Comparison Operators (deprecated in 14.10)
ODBC Scalar Functions Outside Escape Sequences (deprecated in 14.10)
Appendix G ODBC Sample Program Usage Information
Location of the ODBC Sample Program
Sample Output
Executing tdxodbc to Validate Installation
Windows
UNIX/Linux/Mac OS X

Back to home page