Teradata DSN Options | ODBC Driver for Teradata - Teradata DSN Options - ODBC Driver for Teradata

Specify the character set for the session. It is strongly recommended to use the default ASCII session only for 7-bit ASCII characters. UTF8 is the recommended default session character set for all languages including US English. To use a different character set than is chosen by default, specify or select it here.

• A - ANSI
• I - Integer

The recommended settings are either the AAA (default), or the IAA (optional) formats. Because the Integer data type has been deprecated for the TIME format, it is not recommended. For information, see "Integer Time" in Deprecated Features for ODBC Driver for Teradata 16.20 and Later Versions. The last character that represents TIMESTAMP is always ANSI.

DataSourceDNSEntries=undefined (default setting) is recommended for best results. This setting enables ODBC Driver for Teradata to look up 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 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 ODBC Driver for Teradata unless the supplied value is increased.

• No (default) - The driver uses the HELP DATABASE command.
• Yes - SQLTables uses a SELECT statement instead of the HELP DATABASE command when no wildcard characters are used in SQLTables.

• No - Returns column titles, if they are defined; otherwise, returns column names.
• Yes (default) - Returns column names rather than column titles, as required by some applications, such as Crystal Reports.

Column titles for SQLColumns are shown in the LABEL column.

Default value is “Default”.

For more information, see ElicitFile in Teradata® Call-Level Interface Version 2 Reference for Mainframe-Attached Systems, B035-2417, and Teradata Vantage™ - SQL External Routine Programming, B035-1147.

• Yes (default) - Extended statement information is requested and used.

  If extended statement information is available, the ODBC API function SQLDescribeParam is supported and SQLGetFunctions returns SQL_TRUE (supported) for SQL_API_SQLDESCRIBEPARAM.

• No - Extended statement information is not used, even if the database supports it.

  If extended statement information is not available, SQLDescribeParam is not supported and SQLGetFunctions returns SQL_FALSE (not supported) for SQL_API_SQLDESCRIBEPARAM.

• Yes (default) - ODBC Driver for Teradata reads ahead by requesting the next response message from the database when the current response message being processed is not the last. The database can have one request active for each session at any point in time. An active request is either an SQL request which is executing or a request for the next part of the result from an earlier SQL request.
• No - ODBC Driver for Teradata only requests the next response message from the database when the current response message has been processed by the driver.

See ODBC Application Code Page Values (Linux/UNIX and Apple macOS) for a list of valid ODBC application code page values and cautionary information.

Default is 60.

Enter an integer value greater than or equal to 0.

Enter an integer value greater than or equal to 0.

You may want to increase this value if you have a large number of nodes as there may be insufficient time to go through all the nodes for a connection.

You may also want to increase this value if you have intermittent connection issues or slow responding servers due to heavy network traffic, high usage databases, or network delays/latency.

Network latency can be due to many things such as slow responding cloud access, network hops, security packet scanning, etc.

Default is 524288 (512K). The maximum integer value is 16775168.

Default is determined by a configuration option that is set by the TeraGSS program in an XML file called tdgssconfigure.

See Network Security for complete descriptions of authentication mechanisms.

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.

• No (default) - SQL statements are parsed by ODBC Driver for Teradata.
• Yes - SQL statements are sent unmodified to the database without parsing by ODBC Driver for Teradata.

• No (default) - The values of INOUT and OUT parameters are directly updated after the procedure call. Because of this, all parameter markers must be bound to variables before the call.
• Yes - The values of INOUT and OUT parameters are returned as a result set. They can be retrieved from the response by calling SQLFetch and SQLGetData or by calling SQLBindCol followed by SQLFetch. The result set containing the output parameters will be the first result returned by the database preceding any result sets generated by the stored procedure.

For a code sample and additional information, see Stored Procedures Dynamic Result Sets.

N (default) - Disables the print option when stored procedures are created.

P - Enables the print option.

Default is 20.

Default is 30.

Values are Yes for retries or No for no retries. Default is Yes.

The default value is determined by the database based on the option used in the CREATE or MODIFY USER statement.

The number of FastExport data connections that the driver opens, to enable performance improvements for SELECT queries that meet the criteria of the FastExport protocol.

The number of AMPs (Access Module Processors) that are available for your database determines the maximum number of FastExport data connections that can be opened.

If you set this property to a number that is greater than the number of AMPs, the driver only opens a number of connections equal to the number of AMPs.

• N - Created without SPL text.
• Y (default) - Created with SPL text.

This option specifies which TLS mode ODBC Driver for Teradata operates in.

Valid values:

Prefer

This is the driver default. In most circumstances, the driver prioritizes connecting with HTTPS port. If failed, then driver would fall back to try connecting with TDMST port.

Allow

In most circumstances, the driver takes priority connecting with TDMST port. If that connection fails, then the driver falls back to try connecting with HTTPS port.

Disable

Driver only connects on TDMST port.

Require

Driver only connects on the HTTPS port.

Verify-CA

Same as “Require” mode with additional verification of the server Certificate Authority (CA) certificate against the configured CA certificates.

Verify-Full

Same as “Verify-CA” mode with additional host name identity validation.

Currently only TLSv1.2 is supported.

The default is the default of the operating environment.

This option specifies the full path and name of a .pem file containing one or more certificates for trusted Root and Intermediate CAs. If SSL Mode is not set to Verify-CA or Verify-Full, SSL CA File Name or SSL CA Path will be ignored.

This option specifies the full path of the directory containing the root certificates for trusted CAs. If SSL Mode is not set to Verify-CA or Verify-Full, SSL CA File Name or SSL CA Path will be ignored.

Require

The connector would establish a connection only if the certificate status is good, otherwise it would fail.

Allow

The connector would establish a connection only if the certificate status is good/ unknown/ TryLater/ InternalError/ OCSP URI cannot be reached. If certificate status is revoked, the connector would not establish the connection.

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 and Translation DLLs.

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.

Default is 1025.

Default is 443.

• Default: The driver does not use FastExport for any queries, and only runs queries using the standard protocol.
• FastExport: When connected to a database that supports FastExport, the driver uses it to run queries that meet the FastExport criteria. For all other queries, the driver falls back to using the standard protocol.

Specifies the fully qualified path where UDF source files will be found. If defined, the driver looks at this location for files the database requests, unless the database gives a fully qualified path as part of the file name (field must be empty).

For more information, see "ElicitFile" in Teradata® Call-Level Interface Version 2 Reference for Mainframe-Attached Systems, B035-2417 and Teradata Vantage™ - SQL External Routine Programming, B035-1147.

• No (default) - Encrypt only logon information.
• Yes - Enable data encryption.

SqlStatistics() uses dbc.tablesizeV.