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

ODBC Driver for Teradata User Guide

Product
ODBC Driver for Teradata
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-07-11
dita:mapPath
smj1488824663219.ditamap
dita:ditavalPath
Audience_PDF_product_legacy_odbc_include.ditaval
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

ODBC Driver for Teradata has specific application uses defined for available DSN settings. The following table lists the DSN settings and their specific application use.

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
Using this feature is not recommended, because it is deprecated. For details, see Deprecated SQL Transformations.
CallSupport=[Yes|No]

Or

DisableCALLToEXECConversion=[Yes|No]

Disable CALL to EXEC Conversion
Using this feature is not recommended, because it is deprecated, see CALL to EXEC Conversion (deprecated in 14.10).
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.
Using this feature is not recommended, because it is deprecated, see Deprecated SQL Transformations.
DisablePREPARE=[Yes|No] Disable PREPARE
Using this feature is not recommended, because it is deprecated, see Deprecated SQL Transformations.
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>
Using this feature is not recommended, because it is deprecated, see ODBC-Style Named Indexes (deprecated in 15.00).
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 Teradata DSN Options. To enable the legacy parser through ODBC Administrator in the Windows platform, refer to the description of the "Enable Legacy Parser" check box in Teradata ODBC Driver Options. 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 Configuring a DSN Using ODBC Administrator Tool.
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=<16775168> Maximum Response Buffer Size The default is 64K; for large result sets, this value can be increased up to 16 MB.
MechanismName=<MechanismName>

Or

Authentication=<MechanismName>

Mechanism
MechanismKey=<Value>

Or

AuthenticationParameter=<Value>

Parameter
NoScan=[Yes|No] Disable Parsing
Order=[<0123456789>]
Using this feature is not recommended, because it is deprecated, see ODBC-Style Named Indexes (deprecated in 15.00).
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 Teradata ODBC Driver Options. To enable the legacy parser through ODBC Administrator in the Windows platform, refer to the description of the "Enable Legacy Parser" check box in Teradata ODBC Driver Options. 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 Configuring a DSN Using ODBC Administrator Tool.
OutputAsResultSet=[Yes|No] Return Output Parameters As ResultSet
Using this feature is not recommended, because it is deprecated, see DSN Option to Return Output Parameters as ResultSet.
PrintOption=[N|P] ProcedureWithPrintStmt
ReconnectWait=<integer> Redisplay Reconnect Wait
Using this feature is not recommended, because it is deprecated for ODBC Driver for Teradata 14.10, see Redisplay Reconnect Wait DSN Option 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.
Using this feature is not recommended, because it is deprecated, see DSN Option for RunInQuietMode.
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
Using this feature is not recommended, because it is deprecated, see Deprecated SQL Transformations.
StCheckLevel=[0|1|2] State Check Level
Using this feature is not recommended, because it is deprecated, see Deprecated SQL Transformations.
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
Using this feature is not recommended, because it is deprecated, see ODBC Scalar Functions Outside Escape Sequences (deprecated in 14.10).
Use NULL for Catalog Name
Use Regional Settings for Decimal Symbol
UseXViews=[Yes|No] Use X Views
ClientKanjiFormat=[SJIS|EUC|BIG5|Network Korean|GB]
Because this option is deprecated for UNIX and Linux, it is no longer recommended for usage on these systems. For details, see Deprecated SQL Transformations