Click the Options button in the ODBC Driver Setup for Teradata Database dialog box for the Driver Options dialog box to appear. Use this dialog box to configure additional options and formats. Teradata ODBC Driver Options are listed in the table below.
|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 Teradata DSN Options.
|Use X Views||Default = Cleared
Determines whether the X View is used.
See the “UseXViews=[Yes|No]” option in Teradata DSN Options.
|No HELP DATABASE||Default = Cleared
Determines whether the Help Database is used.
See the “DontUseHelpDatabase=[Yes|No]” option in Teradata DSN Options.
|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 Teradata DSN Options.
|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.
See the “NoScan=[Yes|No]” option in Teradata DSN Options.
|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.
|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.
|Return Output Parameters As ResultSet||
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.
See the OutputAsResultSet=[Yes|No] description for this option in Teradata DSN Options.
|Enable Data Encryption||Default = Cleared
When selected, ODBC Driver uses Data Encryption, causing ODBC Driver for Teradata and Teradata Database to communicate with each other in encrypted manner.
When 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 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 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 AAA. IAA is optional. 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 New Teradata ODBC Driver.
See the “DateTimeFormat=[A|I]AA” option in Teradata DSN Options.
|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:
When 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 set to No, the behavior of requests that insert into identity columns is not changed.
Default = NOTSET
Enables Unicode Pass Through Mode for the ODBC Application.
The default value is NOTSET, which means that the UPT Mode set by the database is used. The ODBC Driver for Teradata does not send anything to the database when this option is set.
UPTON: ODBC Driver for Teradata sends “SET SESSION CHARACTER SET UNICODE PASS THROUGH ON” to the database while connecting, thereby enabling UPT MODE for that session.
UPTOFF: ODBC Driver for Teradata sends “SET SESSION CHARACTER SET UNICODE PASS THROUGH OFF” to the database while connecting, thereby disabling UPT MODE for that session.
See the "UPTMode=[NotSet|UPTOn|UPTOff]" option in Teradata DSN Options.
|Enable Client Side UDF Source||
When cleared, ODBC Driver for Teradata will not support UDF source file uploads.
See the "EnableUDFUpload=[Yes|No] option in Teradata DSN Options.
|UDF Upload Path||
Fully qualified path where 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.
No relative paths using “..” are allowed in this value.
The default value displayed in the field (Please enter the UDF folder path) MUST be changed to the value you wish to use (either a valid path or empty). Delete the default value to leave the field empty.
See "UDFUploadPath=<path>" option in Teradata DSN Options.
|Warning group box|
Click to bring up the dialog box. The dialog box contains further setting options available; however, it is strongly recommended NOT to change these settings.