15.10 - Teradata ODBC Driver Options - ODBC Driver for Teradata

ODBC Driver for Teradata User Guide

Product
ODBC Driver for Teradata
Release Number
15.10
Content Type
User Guide
Publication ID
B035-2509-035K
Language
English (United States)

Click the Options button in the ODBC Driver Setup for Teradata Database dialog box for the Teradata ODBC Driver Options dialog box to appear. Use this dialog box to configure additional options and formats.

 

Table 12: Teradata ODBC Driver Options 

Field, Check Box, or Button

Description

Use Column Names

Default = Selected

Determines whether ODBC Driver for Teradata returns column names or column titles

See the “DontUseTitles=[Yes|No]” option in Table 23 on page 66.

Disable Async

Default = Cleared

Determines whether ODBC Driver for Teradata operates in synchronous or asynchronous mode

See the “DisableAsync=[Yes|No]” option in Table 23 on page 66.

Using this feature is not recommended, because it is deprecated. For details, see Appendix E: “Deprecated Features.”.

Use X Views

Default = Cleared

Determines whether the X View is used

See the “UseXViews=[Yes|No]” option in Table 23 on page 66.

No HELP DATABASE

Default = Cleared

Determines whether the Help Database is used

See the “DontUseHelpDatabase=[Yes|No]” option in Table 23 on page 66.

Ignore Search Patterns

Default = Cleared

Determines whether search pattern characters _ and % are used in search patterns or are passed as regular characters.

See the “IgnoreODBCSearchPattern=[Yes|No]” option in Table 23 on page 66.

Enable Reconnect

Default = Cleared

Causes ODBC Driver for Teradata to determine if sessions on Teradata are to be reconnected after a system crash or reset is detected.

See the “EnableReconnect=[Yes|No]” option in Table 23 on page 66.

Run in Quiet Mode

Default = Selected

Controls whether message boxes appear.

See the “RunInQuietMode=[Yes|No]” option in Table 23 on page 66.

Using this option is not recommended, because it is deprecated. For more information, see “DSN Option for RunInQuietMode” on page 165the ODBC Driver for Teradata User Guide.

Disable Parsing

Default = Cleared

Disables or enables parsing of SQL statements by ODBC Driver for Teradata. When parsing is enabled, the driver parses SQL statements and transforms ODBC escape sequences into SQL.

  • When selected, ODBC Driver for Teradata does not parse SQL statements.
  • When cleared, SQL statements are parsed.
  • See the “NoScan=[Yes|No]” option in Table 23 on page 66.

    Enable Legacy Parser

    Default = Cleared

  • When selected, ODBC Driver for Teradata parses SQL statements using the legacy parser.
  • When cleared, SQL statements are parsed using the new parser.
  • Note: This setting is ignored if parsing is disabled ("Disable Parsing" is selected). No mapping takes place if the parser is disabled.

    See the "EnableLegacyParser=[Yes|No]" option in Table  on page 69.

    Log Error Events

    Default = Cleared

    When selected, ODBC Driver for Teradata performs error logging that appears in the Event Viewer.

    When cleared, error logging is not performed.

    Disable CALL to EXEC Conversion

    When selected, CALL statements remain as CALL statements.

    Default = Selected. (When selected, do not select the Disable Parsing option.)

    When cleared, ODBC Driver for Teradata converts CALL statements within an escape clause (that is, {CALL <name>(..)}) to EXEC statements.

    Note: Clearing this option is not recommended, because it is deprecated. For details, see “CALL to EXEC Conversion (deprecated in 14.10)” on page 172the ODBC Driver for Teradata User Guide.

    See the “DisableCALLToEXECConversion=[Yes|No]” option in Table 23 on page 66.

    Use Regional Settings for Decimal Symbol

    Default = Selected

    (Windows) Allows the application to decide which symbol is used as a decimal separator while retrieving decimal data.

    When selected, ODBC Driver for Teradata uses regional settings to determine the decimal symbol.

    If cleared, ODBC Driver for Teradata uses a “.” character as the decimal symbol and ignores the regional settings.

    Use Native Large Object Support

    Default = Selected

    Leaving the default value selected is recommended, because this setting is deprecated. For details, see Appendix E: “Deprecated Features”the ODBC Driver for Teradata User Guide.

    Enables LOB support. Impacts data type mapping within ODBC Driver for Teradata. See the description for this option on UNIX systems in “UseNativeLOBSupport=[Yes|No]” on page 78the ODBC Driver for Teradata User Guide.

    Return Output Parameters As ResultSet

    Note: Using this feature is not recommended, because it is deprecated. For details, see the ODBC Driver for Teradata User Guide“DSN Option to Return Output Parameters as ResultSet” on page 165.

    Default = Cleared

    Determines how stored procedure output parameters are retrieved by ODBC Driver for Teradata

    When selected–the values of INOUT and OUT parameters are returned as a result set. The values can be retrieved by calling SQLFetch and SQLGetData, or SQLBindCol followed by SQLFetch. The result set containing the output parameters is the first returned by the database, preceding any generated by a stored procedure.

    When cleared–the values of INOUT and OUT parameters are directly updated after the procedure call. All parameter markers must therefore be bound to variables before the call.

    Enable Data Encryption

    Default = Cleared

    When Enable Data Encryption is checked – the option directs the ODBC Driver to use Data Encryption, causing ODBC Driver for Teradata and Teradata Database to communicate with each other in encrypted manner.

    When Enable Data Encryption is cleared–Data Encryption is disabled.

    Enable Extended Statement Information

    Default = Selected

    Determines whether extended statement information is to be used by ODBC Driver for Teradata, provided that it is available from Teradata Database. Database versions from V2R6.2 and up support extended statement information, including metadata for parameters used in SQL requests and columns in result sets.

    When EnableExtendedStmtInfo is Selected – ODBC Driver for Teradata requests and uses extended statement information from the database if supported. If extended statement information is available, then the ODBC API function SQLDescribeParam is supported and SQLGetFunctions returns SQL_TRUE (supported) for SQL_API_SQLDESCRIBEPARAM.

    When EnableExtendedStmtInfo is cleared – ODBC Driver for Teradata does not request or use extended statement information from the database, even if supported. If extended statement information is unavailable, SQLDescribeParam is not supported and SQLGetFunctions returns SQL_FALSE (not supported) for SQL_API_SQLDESCRIBEPARAM.

    Session Mode

    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 Teradata Database CREATE or MODIFY USER statement.

    DateTime Format

    Assigns the ANSI formats for DATE, TIME, and TIMESTAMP.

    The default setting is IAA. 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 166the ODBC Driver for Teradata User Guide.

    See the “DateTimeFormat=[[I|A] [I|A] [I|A]]” option in Table 23 on page 66.

    Return Generated Keys

    Default = No

    Determines the result from requests that insert 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. The setting of Return Generated Keys has no effect when using a pre-V2R6.2 database server.

    Valid values are No, Identity Column, and Whole Row:

  • No = Auto-generated key retrieval is disabled (default)
  • Identity Column = Retrieve identity column only
  • Whole Row = Retrieve entire row(s)
  • When Return Generated Keys is set to Identity Column or Whole Row, a request that inserts into tables containing identity columns returns two results: a row count with the number of inserted rows and a result set containing either the auto-generated keys as a single column or the complete rows inserted. The insert request becomes similar to a macro that first inserts and then selects the identity column or all columns of the rows just inserted.

    When Return Generated Keys is set to No, the behavior of requests that insert into identity columns is not changed.

    Warning group box

    Advanced

    Click to bring up the Teradata ODBC Driver Advanced Options dialog box. The dialog box contains further setting options available; however, it is strongly recommended NOT to change these settings.

  • ODBC Driver Setup Parameters
  • Teradata ODBC Driver Advanced Options