Configuring Advanced Options

You can configure advanced options to modify the behavior of the connector.

Important:

Important:

Do not modify the advanced connector options unless your system administrator instructs you to do so. These options are needed in specific scenarios only, and may cause unexpected connector behavior if not configured appropriately.

To configure advanced options:

  1. To access advanced options, open the ODBC Data Source Administrator where you created the DSN, then select the DSN, then click Configure, then click Options, then click Advanced.
  2. In the Maximum Response Buffer field, specify the maximum size of the response buffer for SQL requests, in kilobytes.
  3. In the TDMST Port Number field, specify the number of the port used to access Teradata Database.
  4. In the Translation DLL Name field, specify the .dll file that contains functions for translating all the data that is transferred between the Teradata server and the connector. This .dll file is used for translation if local character sets are not supported by Teradata Database or the connector.
  5. In the Translation Option field, specify the options used by the Translation DLL file. The required options may vary depending on the Translation DLL file being used.
  6. In the Login Timeout field, specify the number of seconds to wait for a response when logging in to the database.
  7. To enable the print option when creating stored procedures, from the Procedure With Print Stmt drop-down list, select P.
  8. To enable the SPL option when creating stored procedures, from the Procedure With SPL Source drop-down list, select Y.
  9. In the Data Source DNS Entries field, specify how the connector determines which DNS entry to use by doing one of the following:
    • To resolve DNS entries dynamically, leave the field empty.
    • Or, to use DNS lookup, type 0.
    • Or, to specify a number of DNS entries to use in a round-robin fashion, type the number of entries.
  10. To use the TCP_NODELAY setting, select the Use TCP_NODELAY check box.
  11. To specify NULL for the Catalog Name parameter in all Catalog API functions, select the Use NULL For Catalog Name check box.
  12. To have the connector request the next response message while it is processing the current response message, select the Enable Read Ahead check box.
  13. To retry socket system calls at the connector level instead of the application level, select the Retry System Calls (EINTR) check box.
  14. To optimize retrieval for Large Object (LOB) data that meets specified size requirements, enable Smart LOB (SLOB) Mode by doing the following. For detailed information about the supported LOB retrieval modes, see LOB Retrieval Modes.
    1. In the Max Single LOB Bytes field, type the maximum size of the LOBs (in bytes) that the connector can retrieve using SLOB Mode. LOBs that exceed this size are retrieved using Deferred Mode instead.
    2. In the Max Total LOB Bytes Per Row field, type the maximum size of LOB data per row (in bytes) that the connector can retrieve using SLOB Mode. If the total amount of LOB data being retrieved from a row exceeds this size, then after using SLOB Mode to retrieve LOBs up to this size limit, the connector uses Deferred Mode to retrieve the remaining LOBs from that row.
    3. If you are retrieving LOB data from columns in sequential order, select the Use Sequential Retrieval Only check box.
      4. Important:

      Important:

      If you enable this option but then retrieve LOB data from columns in a non-sequential order, connector performance may decrease. In this scenario, the connector discards the LOBs that are returned through SLOB Mode and must then retrieve them all again using Deferred Mode.

  15. To enable compatibility with applications that use Microsoft Access Jet databases by using DATE data in TIMESTAMP parameters, select the Use DATE Data For TIMESTAMP Parameters check box.
  16. To provide backwards compatibility for ODBC 2.x applications that use noncompliant search patterns, select the Enable Custom Catalog Mode For 2.x Applications check box.
  17. To return an empty string in the CREATE_PARAMS column when you call SQLGetTypeInfo for SQL_TIMESTAMP data, select the Return Empty String In CREATE_PARAMS Column For SQL_TIMESTAMP check box.
  18. To return a hard-coded value as the maximum length of SQL_CHAR and SQL_VARCHAR columns, select the Return Max CHAR/VARCHAR Length As 32K check box.

    19. Note:

    • Enabling this option prevents the returned column size from causing numeric overflows in Microsoft Access.
    • The hard-coded value is either 32000 or 64000, depending on the setting specified for the Session Character Set connector option.
  19. To save your settings and close the Advanced Options dialog box, click OK.

Related topics