16.20 - ODBC Specific Limitations - Teradata SQL Assistant

Teradata® SQL Assistant for Windows User Guide

Product
Teradata SQL Assistant
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2020-01-03
dita:mapPath
gfk1537201040714.ditamap
dita:ditavalPath
ft:empty

General

  • Batch Import functionality is not available.
  • The Edit Table function is not available.
  • Temporary, and Queue, tables are not identified as such in the database tree.
  • Time Zone information will not be displayed.
  • Time fields do not display fractional seconds or Time Zone information.
  • Decimal values with more than 28 digits might display incorrectly.
  • Retrieving Interval data or vendor specific types might limit the functionality of the resultset as follows:
    • Decimal data might display 'n' decimal places ('n' is the value for Float data in Options).
    • Date columns might be displayed as Timestamps and might not use your selected format.
    • Timestamp columns may not display fractional seconds.
    • BLOB/CLOB columns might be displayed as regular BYTE/CHAR data.

Teradata

  • CLOBs can only be returned using the UTF-16 Session Character Set (unless < 2K).
  • Only type 'F' User Defined Functions are listed in the Database Explorer Tree.
  • FLOAT columns might be reported as 'TIME' in the Database Explorer Tree if they have a Format clause that looks like a time, for example, '99:99:99'.
  • If a macro (or execute parallel) returns zero rows from a Select statement, no rows are returned from any later Select statements in that macro or parallel query.
  • The location of Syntax errors are not highlighted.

DB2

In order to return BLOBs and CLOBs correctly you must either set LongDataCompat=1 in the db2cli.ini file or use the Define ODBC Data Source dialog box to set this option in the Data Source itself.
  1. Open the Define ODBC Data Source dialog, select the data source, then click Configure.
  2. Click Add on the Advanced tab, then select LongDataCompat from the list.
  3. Select the As LongVarchar data option.

Oracle

  • Procedure and Function parameters are not displayed in the Database Explorer Tree.
  • Retrieval of INTERVAL or other 'unknown' types causes the ODBC driver to crash.
  • .NET cuts off the first byte when selecting columns defined as RAW(n). This renders the binary object useless. Define the columns as BLOB instead.

PostgresSQL

Import only works if all columns can be converted to CHAR type. PostgreSQL has no ability to convert a string to a numeric, for example.

MySQL

You must use MySQL Connect/ODBC 3.51.27, not 5.1.5. (Future versions might remove this limitation.) The older 5.1.x ODBC drivers do not return catalog information (tables and columns, for example).