Chapter 8 ODBC Driver for Teradata Application Development - ODBC Driver for Teradata

ODBC Driver for Teradata User Guide

Product
ODBC Driver for Teradata
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

This chapter provides information needed to use ODBC Driver for Teradata to access Teradata features and extensions to the ODBC standard.

This chapter is divided into the following sections:

 

Section Heading

Contents

Teradata Extensions to the ODBC Standard

Extensions above and beyond ODBC that ODBC Driver for Teradata supports for Teradata Database

Connection Pooling (Windows and Apple OS X)

Reusing existing connections that are not currently active

Stored Procedures

A set of control and condition handling statements that provide a procedural interface to Teradata Database

Auto-Generated Key Retrieval

Information about using the auto-generated key configuration option

SQL Descriptor Fields

Information on how ODBC Driver for Teradata uses the extended statement information configuration option

International Character Set Support

How to configure the driver for character set support

Atomic UPSERT

Support for UPSERT in ODBC Driver for Teradata

ANSI Date and Time Restrictions

Restrictions that occur for ANSI Date/Time

Period Data Types

Information about using Teradata Period data types

Geospatial Types

Information about using geospatial and GeoSequence types

Restrictions

Current restrictions for ODBC Driver for Teradata

ANSI Migration Issues

Migration issues, including: transaction semantics, data truncation, duplicate rows, updatable cursors, and case sensitivity

Configuration Characteristics

Access locks and password expiration

SQL Considerations

SQL compatibility issues

DSN Settings for Third-party Applications

Lists third-party DSN settings and their specific application