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

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