15.10 - DSN Settings for Third-party Applications - ODBC Driver for Teradata

ODBC Driver for Teradata User Guide

prodname
ODBC Driver for Teradata
vrm_release
15.10
category
User Guide
featnum
B035-2509-035K

ODBC Driver for Teradata has specific application uses defined for available DSN settings. Table 52 lists the DSN settings and their specific application use.

 

Table 52: DSN Settings for Third-party Applications 

ODBC.INI Setting Name

Name in DSN setup dialog

Specific Application Use

AccountString=<account>

Or

Account=<account>

Account String

AppCatalogDB=<database name>

Application Catalog Database

PowerBuilder

Note: Using this feature is not recommended, because it is deprecated. For details, see Appendix E: “Deprecated Features.”

CallSupport=[Yes|No]

Or

DisableCALLToEXECConversion=[Yes|No]

Disable CALL to EXEC Conversion

Note: Using this feature is not recommended, because it is deprecated, see “CALL to EXEC Conversion (deprecated in 14.10)” on page 172.

CharacterSet=<charset name>

Or

CharSet=<charset name>

Session Character Set

DateTimeFormat=[[I|A] [I|A][I|A]]

DateTime Format

DefaultDatabase=<database-name>

Or

Database=<database-name>

Default Database

DisableAsync=[Yes|No]

Disable Async.

Note: Using this feature is not recommended, because it is deprecated, see Appendix E: “Deprecated Features.”

DisablePREPARE=[Yes|No]

Disable PREPARE

Note: Using this feature is not recommended, because it is deprecated, see Appendix E: “Deprecated Features.”

DontUseHelpDatabase=[Yes|No]

Or

DontUseHelpDB=[Yes|No]

No HELP DATABASE

EnableExtendedStmtInfo=[Yes|No]

Enable Extended Statement Information

EnableReadAhead=[Yes|No]

Enable read-ahead

EnableReconnect=[Yes|No]

Enable Reconnect

IANAAppCodePage=<ODBC application code page>

This is set for application-specific code page number when using Unicode

IgnoreODBCSearchPattern=[Yes|No]

Or

IgnoreSearchPat=[Yes|No]

Ignore Search Patterns

IndexName[0-9]=<indexname (column identifiers) dbn.tablename>

Note: Using this feature is not recommended, because it is deprecated, see “ODBC-Style Named Indexes (deprecated in 15.00)” on page 171.

Note: ODBC-style named indexes only work with the legacy parser. To enable the legacy parser through odbc.ini in UNIX/Linux and Apple OS X platforms, refer to the description of the "EnableLegacyParser=[Yes|No]" option in Table 23 on page 66. To enable the legacy parser through ODBC Administrator in the Windows platform, refer to the description of the "Enable Legacy Parser" check box in Table 12 on page 41. To enable the legacy parser through ODBC Administrator in the Apple OS X platform, refer to the description of the "Enable Legacy Parser" check box in Table 3 on page 5.

Integrated Security=[Yes|No]

Use Integrated Security

Log Error Events

LoginTimeout=<integer0>

Login Timeout

Increase the default 20 seconds to higher value for troubleshooting purposes only. This is a temporary workaround.

MaxRespSize=<integer=<1048576>

Maximum Response Buffer Size

The default is 64K; for large result sets, this value can be increased up to 1 MB

MechanismName=<MechanismName>

Or

Authentication=<MechanismName>

Mechanism

MechanismKey=<Value>

Or

AuthenticationParameter=<Value>

Parameter

NoScan=[Yes|No]

Disable Parsing

Order=[<0123456789>]

Note: Using this feature is not recommended, because it is deprecated, see “ODBC-Style Named Indexes (deprecated in 15.00)” on page 171.

Note: ODBC-style named indexes only work with the legacy parser. To enable the legacy parser through odbc.ini in UNIX/Linux and Apple OS X platforms, refer to the description of the "EnableLegacyParser=[Yes|No]" option in Table 23 on page 66. To enable the legacy parser through ODBC Administrator in the Windows platform, refer to the description of the "Enable Legacy Parser" check box in Table 12 on page 41. To enable the legacy parser through ODBC Administrator in the Apple OS X platform, refer to the description of the "Enable Legacy Parser" check box in Table 3 on page 5.

OutputAsResultSet=[Yes|No]

Return Output Parameters As ResultSet

Note: Using this feature is not recommended, because it is deprecated, see “DSN Option to Return Output Parameters as ResultSet” on page 165.

PrintOption=[N|P]

ProcedureWithPrintStmt

ReconnectWait=<integer>

Redisplay Reconnect Wait

Note: Using this feature is not recommended, because it is deprecated for ODBC Driver for Teradata 14.10, see “Redisplay Reconnect Wait DSN Option” on page 166 for details.

retryOnEINTR

Retry system calls (EINTR)

KXEN

Return Empty string in CREATE_PARAMS columns for SQL_TIMESTAMP

MS Access

ReturnGeneratedKeys=<value>

Return Generated Keys

Return max. CHAR/VARCHAR length as 32K

MS Access

RunInQuietMode=[Yes|No]

Or

QuietMode=[Yes|No]

Run in Quiet Mode

Prevents a dialog box from displaying when input is not required. Do disable this feature, set it to No.

Note: Using this feature is not recommended, because it is deprecated, see “DSN Option for RunInQuietMode” on page 165.

SessionMode=[Teradata|ANSI]

Session Mode

Set to ANSI to resolve application getting too many end transaction messages.

SplOption=[Yes|No]

ProcedureWithSPLSource

SQLWithCommentsOrParenthesis=[Yes|No]

Disable Prepare for SQL with comments or parenthesis

Note: Using this feature is not recommended, because it is deprecated, see Appendix E: “Deprecated Features.”

StCheckLevel=[0|1|2]

State Check Level

Note: Using this feature is not recommended, because it is deprecated, see Appendix E: “Deprecated Features.”

TCPNoDelay=[Yes|No]

Use TCP_NODELAY

Translation DLL=<path>

Translation DLL Name

Translation Option=<option>

Translation Option

TDMSTPortNumber=<integer>

TDMST Port Number

Set to another port number if port 1025 is already used. By default, the Teradata Gateway is listening to port 1025.

USE2XAPPCUSTOMCATALOGMODE=[Yes|No]

Or

2XAPPCUSTOMCATALOGMODE=[Yes|No]

Enable Custom Catalog Mode for 2.x Applications

MS Excel
Importing data into an Excel 2000 spreadsheet by SQL query (using Data>>Get External Data>>New Database Query)

UseColumnNames=[Yes|No]

Or

DontUseTitles=[Yes|No]

Use Column Names

Crystal Reports

UseDataEncryption=[Yes|No]

Or

DataEncryption=[Yes|No]

Enable Data Encryption

Use DATE data for TIMESTAMP parameters

MS Access and other applications that are using Microsoft Access Jet databases

UseNativeLOBSupport=[Yes|No]

Use Native Large Object Support

Note: Using this feature is not recommended, because it is deprecated, see “DSN Option for Native Large Object Support” on page 164.

Use NULL for Catalog Name

Use Regional Settings for Decimal Symbol

UseXViews=[Yes|No]

Use X Views

ClientKanjiFormat=[SJIS|EUC|BIG5|Network Korean|GB]

Note: Because this option is deprecated for UNIX and Linux, it is no longer recommended for usage on these systems. For details, see Appendix E: “Deprecated Features.”