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