The keyword options in the following table can be added to the Data Source Specification and Default Data Source Specification sections of the odbc.ini file. The options can only be configured through the odbc.ini file.
ODBC Driver for Teradata has established specific application uses for available DSN settings. For details, see “DSN Settings for Third-party Applications” on page 147.
Keyword/Synonym |
Description |
||
AccountString=<account> Or Account=<account> |
Specifies the AccountString to be entered during database logon. If unspecified, the database defaults to the AccountString value specified when the user was created or modified. Note: This option can help isolate users by determining the applications users are running or restricting users from logging on. |
||
AppCatalogDB=<database name> |
Includes the specified database in table searches (including default tables) if SQLTables is called with a NULL value for the database parameters. Use this option for applications, such as PowerBuilder, that require a database for their system catalog tables. By default, no database is specified. Using this feature is not recommended, because it is deprecated. For details, see Appendix E: “Deprecated Features.” |
||
CallSupport=[Yes | No] Or DisableCALLToEXECConversion=[Yes | No] |
Specifies whether CALL statements within an escape clause (that is, [CALL <name>(..)]) are converted to EXEC statements. Note: Setting this option to No is not recommended, because it is deprecated. For details, see “CALL to EXEC Conversion (deprecated in 14.10)” on page 172. Parsing of SQL statements by ODBC Driver for Teradata is mandatory for CALL statements with escape clauses to work. Set the NoScan option to No. |
||
CharacterSet=<charset name> Or Charset=<charset name> |
Specifies the session character set. Default is ASCII. The character set name could be a user-defined character set or one of the following, as defined by Teradata: Note: These character sets must be installed on Teradata Database. See International Character Set Support. |
||
DateTimeFormat=[[A|I] [A] [A] |
Specifies the format of DATE, TIME, and TIMESTAMP data types. The three-character specification represents: The recommended settings are either IAA (default), or the AAA format. Because the Integer data type has been deprecated for the TIME format, it is not recommended. For information, see “DSN Option for Integer Time” on page 166. The last character that represents TIMESTAMP is always ANSI. |
||
DisableAsync=[Yes|No] |
Specifies if ODBC Driver for Teradata supports asynchronous operations. By default, OBDC driver for Teradata executes functions synchronously, that is the driver does not return control to the application until a function call has completed processing. ODBC driver allows certain functions to be executed asynchronously, however. In that case, control is returned to the application before the function call has completed processing. An application can specify that it wants to execute asynchronously via SQLSetStmtAttr() or SQLSetConnectionsttr(). The DisableAsync = Yes setting disables any attempts to run in asynchronous mode. Using this feature is not recommended, because it is deprecated. For details, see Appendix E: “Deprecated Features.” |
||
DisablePREPARE=[Yes | No] |
Instructs Teradata Database to prepare statements executed through SQLExecDirect.
Using this feature is not recommended, because it is deprecated. For details, see Appendix E: “Deprecated Features.” |
||
DontUseHelpDatabase=[Yes|No] Or DontUseHelpDB=<[Yes|No] |
Specifies whether the Help Database is used. Note: SQLTables uses dbc.tables or dbc.tablesX, depending on the UseXViews setting. |
||
DontUseTitles=[Yes|No] |
Specifies whether column names or column titles are returned. Column titles for SQLColumns are shown in the LABEL column. |
||
EnableExtendedStmtInfo=[Yes | No] |
Specifies whether extended statement information is used when it is available from the database. If extended statement information is available, the ODBC API function SQLDescribeParam is supported and SQLGetFunctions returns SQL_TRUE (supported) for SQL_API_SQLDESCRIBEPARAM. If extended statement information is not available, SQLDescribeParam is not supported and SQLGetFunctions returns SQL_FALSE (not supported) for SQL_API_SQLDESCRIBEPARAM. Note: Teradata Database versions V2R6.2 and up support extended statement information, which includes additional metadata for parameters used in SQL requests and for columns in result sets. |
||
EnableLegacyParser=[Yes | No] |
Enables or disables the legacy ODBC parser. The legacy parser is not ODBC standard and modifies SQL text outside of ODBC escape sequences to provide compatibility with early Teradata ODBC applications. Part of the legacy parser is to remove all SQL comments from the SQL parsed by the ODBC driver. The legacy parser is provided for backward compatibility. An application requiring the legacy parser must use SQL compatible with Teradata SQL 15.00. Note: This setting is ignored if parsing is disabled (NoScan=Yes). No mapping takes place if the parser is disabled. Note: Using this feature is not recommended, because it is deprecated. For more information about the SQL modifications please refer to Appendix F: “Deprecated SQL Transformations”. |
||
EnableReadAhead=[Yes | No] |
Specifies whether the ODBC Driver performs read-ahead to receive the next response message while the current message is being processed. |
||
EnableReconnect=[Yes | No] |
Specifies whether sessions on Teradata Database get reconnected after a system crash or reset. Note: After a session is reconnected, applications can expect to receive error messages describing why the ODBC function failed and a status report describing the post-recovery state. |
||
IANAAppCodePage=<ODBC application code page> |
The current ODBC application code page is defined as IANAAppCodePage. See Table 42 on page 124 for a list of valid ODBC application code page values and cautionary information. |
||
IgnoreODBCSearchPattern=[Yes|No] Or IgnoreSearchPat=<[Yes|No] |
Specifies that characters _ and % work like regular wildcard characters for values given to table names, schema names, and so forth when passed to catalog functions, such as SQLTables. This option is useful for applications, such as Microsoft Access, that do not support search patterns. Note: This setting causes Microsoft Access to use the Data Source section of the odbc.ini file to process search patterns. Note: SQL_SEARCH_PATTERN_ESCAPE returns an empty string. |
||
IndexName[0-9]=<indexname (column identifiers)dbn.tablename> |
Specifies index names and the tables that use them. Supports user-defined ODBC‑style named indexes. Index names are defined independently for each data source entry, and are only defined when an index is created. IndexName entries are generated when an application creates a named index. IndexName entries are removed when a DROP INDEX command is issued. which affects the named index, or when a DROP TABLE command is issued, which destroys the table where an index exists. IndexName entries are re-used on a first in-first out basis when all other entries are used. By default, no index names and tables are specified. Using this feature is not recommended, because it is deprecated. For details, 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. |
||
LoginTimeout=<integer≥0> |
Defines the number of paused seconds before a virtual circuit is established with Teradata Database for login. Default is 20. Enter an integer value greater than or equal to 0. |
||
MaxRespSize=<integer≤1048576> |
Limits the Teradata response buffer size for SQL requests. Default is 65536 (64K). The maximum integer value is 1048576. This value can be adjusted dynamically if Teradata cannot send a result within the limited packet size defined: |
||
MechanismName=<MechanismName> Or Authentication=<MechanismName> |
Identifies the authentication mechanism used for connections to the data source. Default is determined by a configuration option that is set by the TeraGSS program in an XML file called tdgssconfigure. Valid values: See Chapter 7: “Network Security” for complete descriptions of authentication mechanisms. |
||
MechanismKey=<Value> Or AuthenticationParameter=<Value |
Value = string A string of characters regarded as a parameter to the authentication mechanism. It is opaque for ODBC Driver for Teradata and is passed on to the Teradata authentication software called to set the mechanism.
You can use a Teradata Wallet reference string instead of a plain text MechanismKey value by specifying the $tdwallet() token. For example: MechanismKey=$tdwallet(RefString) For more information, see “Teradata Wallet” on page 98. |
||
NoScan=[Yes | No] |
Enables or disables parsing of SQL statements by ODBC Driver for Teradata. When enabled, the driver transforms ODBC escape sequences to SQL.
|
||
Order=[<0123456789>] |
Indicates the order of creating IndexName entries and determines which indexes are reused first when all IndexName entries have been exhausted. ODBC Driver for Teradata creates this UNIX system option entry to support ODBC‑style named indexes. ODBC Driver for Teradata writes back to the odbc.ini file with the SQLWritePrivateProfileString API. A maximum of 10 index names are maintained. By default, no order is specified, and no IndexName entries are created. Using this feature is not recommended, because it is deprecated. For details, 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] |
Note: Using this feature is not recommended, because it is deprecated. For details, see “DSN Option to Return Output Parameters as ResultSet” on page 165. Determines how stored procedure output parameters are retrieved. |
||
PrintOption=[N | P] |
Specifies the print option for stored procedures. N (default) - Disables the print option when stored procedures are created. P - Enables the print option. |
||
ReconnectWait=<integer> |
Note: Using this feature is not recommended, because it is deprecated. Manages the length of time that reconnect messages are displayed during session recovery. This is a user-defined option. Messages are automatically removed when a connection is re-established with the database. Otherwise, the session recovery effort cannot be cancelled. The default is 10. For more information, see “Redisplay Reconnect Wait DSN Option” on page 166. Note: The EnableReconnect option must be set to Yes before the ReconnectWait option is valid. |
||
retryOnEINTR |
Controls whether ODBC Driver for Teradata retries the socket system calls on an EINTR or returns an SQL_ERROR. The affected socket system calls are: Values are Yes for retries or No for no retries. Default is Yes. |
||
ReturnGeneratedKeys=<value> |
Determines the result from requests that insert data into identity columns (INSERT, INSERT ... SELECT, UPSERT, MERGE-INTO). These requests can optionally return a result set containing identity column values (also known as auto-generated keys) for the inserted rows. Auto-generated key retrieval is not supported in Teradata Database versions prior to V2R6.2 and the setting of ReturnGeneratedKeys has no effect when using a pre V2R6.2 database server. |
||
RunInQuietMode=[Yes | No] Or QuietMode=[Yes | No] |
Specifies how standard messages are displayed. Using this option is not recommended, because it is deprecated. For more information, see “DSN Option for RunInQuietMode” on page 165. |
||
SessionMode=[Yes | No] |
Specifies the mode (Teradata or ANSI) for sessions on Teradata Database. The selected mode applies for the duration of the session. The default value is determined by the database based on the option used in the CREATE or MODIFY USER statement. Note: An application cannot set SessionMode programatically. SessionMode can be set only while connecting. |
||
SplOption=[Y | N] |
Specifies the stored procedure language (SPL) option when creating stored procedures. |
||
SQLWithCommentsOrParenthesis=[Yes | No] |
Affects only SQL preparable request statements enclosed in parentheses or preceded by ANSI (--) or Teradata comments (\ * * /). Specifies whether Teradata Database prepares these SQL statements before execution using SQLExecDirect. Note: This option only applies to requests executed using SQLExecDirect. Using this feature is not recommended, because it is deprecated. For details, see Appendix E: “Deprecated Features.” |
||
DataSourceDNSEntries |
The DataSourceDNSEntries DSN option notifies the ODBC Driver for Teradata how many entries are defined in DNS for the database name. The initial value of this option controls how the ODBC Driver for Teradata resolves database names to IP addresses. If this value is not set, the default value is undefined (empty). If multiple database names are provided in ODBC DSN, the DataSourceDNSEntries option is applicable to all names. Note: If a database is identified by IP address instead of a name in the ODBC DSN or connection-string, the DataSourceDNSEntries option is ignored. DataSourceDNSEntries=undefined (default setting) is recommended for best results. This setting enables the ODBC Driver for Teradata to lookup DNS dynamically and find all available COPs for a given database name. Using this approach, ODBC Driver for Teradata will automatically detect new nodes added to the Teradata database (and DNS) in the future, without ODBC modification. DataSourceDNSEntries = 0 indicates that DNS does not contain cop entries for the database name. The database name will only be resolved by itself. No attempt will be made to resolve using a cop suffix. This behavior can be desirable in an environment utilizing DNS to load balance. When DNS is used for load balancing, administrators can configure DNS to provide a different IP address or multiple IP addresses in different order each time the database name is resolved using DNS. DataSourceDNSEntries = value. Entering a non-zero value indicates that DNS contains cop entries for the database name and the last cop entry is value. The first connection attempt will chose a random number between 1 and value. Each subsequent connection will then increment to the next number (round-robin). This approach will not encounter costly DNS resolution failures (how costly depends on how the DNS is configured). However, if additional entries are added to DNS at a later time, they will not be discovered by the ODBC Driver for Teradata unless the supplied value is increased. |
||
StCheckLevel=[0 | 1 | 2] |
Provides enhanced ODBC state checking that detects SQLState 24000 according to the requirements in the ODBC SDK. This is a user-defined option. ODBC Driver for Teradata will not return SQL State 24000 when an ODBC function such as SQLExecute, SQLExecDirect, or an ODBC catalog function generates a result set while another function that generates a result set is called before the first results were fetched or freed. ODBC Driver for Teradata generates a SQL State 24000 error if an application is in an open cursor state and one of the following functions is called: ODBC Driver for Teradata generates an SQL State 24000 error if an application is not in an open cursor state and SQLColAttributes, SQLDescribeCol, or SQLFetch are called. Using this feature is not recommended, because it is deprecated. For details, see Appendix E: “Deprecated Features.” |
||
TCPNoDelay=[Yes | No] |
Specifies whether Transmission Control Protocol (TCP) immediately sends small packets or waits to gather packets into a single, larger packet. This option is valid for the Teradata Data Source Entry. |
||
TranslationDLL=<path> |
Specifies the name of the translation DLL. It is recommended that you assign a fully qualified pathname for the translation DLL. User-defined session character sets can be used without a value for this option. Conversion is then based on the current application code page. For details, see “User-Defined Session Character Set Support” on page 123 and “Translation DLLs” on page 123. |
||
TranslationOption=<integer> |
A 32-bit value with a specific meaning for a given translation DLL. For example, it could specify a certain character set translation. If unspecified, a zero value is passed as an option to SQLDriverToDataSource and SQLDataSourceToDriver of the Translation DLL. |
||
TDMSTPortNumber=<integer> |
Specifies the number of the port that accesses Teradata Database. Default is 1025. Note: Do not change this value unless instructed to do so by Technical Support. |
||
USE2XAPPCUSTOMCATALOGMODE=[Yes | No] Or 2XAPPCUSTOMCATALOGMODE=[Yes | No] |
Provides backwards compatibility for ODBC 2.x applications that use a noncompliant search patterns. Earlier versions of ODBC Driver for Teradata allowed users to create search patterns other than the % search pattern stated in the ODBC Programmer’s Reference specification. On noncompliant systems, if a NULL value is passed to the SQLTables API for the SchemaName argument, the result is a search for tables by userid, DBC, and default database schema names, rather than the % search pattern. |
||
UseDataEncryption=[Yes|No] Or DataEncryption=[Yes | No] |
No (default) - Encrypt only logon information. |
||
UseNativeLOBSupport=[Yes|No] |
Enables native Large Object (LOB) data types. Impacts data type mapping that takes place internally in ODBC driver. Note: It is recommended to retain the default setting, because this option has been deprecated. For details, see “DSN Option for Native Large Object Support” on page 164. |
||
UseXViews=[Yes|No] |
Specifies whether X tables are used. X tables only contain information that users have permission to access. These tables are optional for Teradata, so check to ensure they exist before using the option. SqlStatistics() uses dbc.tablesizeV. |
||
The Linux/UNIX system version of ODBC Driver for Teradata recognizes the following options when the LANG environment variable contains a value recognized by ODBC Driver for Teradata for Japanese, Chinese, or Korean locales. These options are not available on Apple OS X. |
|||
ClientKanjiFormat={SJIS|EUC| |
Note: Using this feature is not recommended, because it is deprecated. For details, see “ClientKanjiFormat (UNIX and Linux systems only)” on page 165. Specifies which character set to use for the user's choice of character set format: Default is set by the user. The data returned is translated from the session character set to the ClientKanjiFormat for SJIS and EUC only. For Big5, NetworkKorean, and GB, this value should match the session character set. |