Preparing the Teradata Environment

In order to use the Adapter for Teradata, NCR Teradata ODBC or CLI clients must be installed and configured and the path to the Teradata ODBC or CLI libraries directory must be added to SYSTEM LIBRARY PATH. See the NCR Teradata documentation for more information about requirements on ODBC or CLI installation.

If you are using the z/OS server, no preconfiguration steps are required. Use the Web Console to configure the Teradata Adapter.

Procedure: How to Set Up the Environment on Microsoft Windows Using ODBC or CLI

On Microsoft Windows, the Teradata environment is set up during the installation of the product.

Procedure: How to Set Up the Environment on UNIX

You can access Teradata using the optional UNIX environment variable, ODBCINI. The ODBCINI variable points to the absolute path of the .odbc.ini file.

For example:

ODBCINI=/usr/odbc/.odbc.ini
export ODBCINI

Note: You must not use ODBCINI, if the $HOME directory contains the .odbc.ini file.

Configuring Teradata CLI for Unicode

The Teradata CLI adapter supports Unicode UTF8 format if:

The Teradata CLI client components are part of release TTU8.0 or higher.
The Teradata database is release V2R6.0 or higher and appropriate language support was enabled during the sysinit process.

Contact your DBA to determine whether international language support has been enabled in your Teradata system and/or consult the Teradata documentation for details about International Character Set Support.

Note that, at the present time, when Unicode is enabled the length of a Teradata Column Name and/or TITLE cannot exceed 21 characters.