Default reverse data type mappings for Teradata data sources

The following table lists the default reverse data type mappings for Teradata data sources.

Table 1. Teradata default reverse data type mappings (Not all columns shown)
Federated Typename Federated Lower Len Federated Upper Len Federated Lower Scale Federated Upper Scale Federated Bit Data Federated Data Operators Remote Typename Remote Length Remote Scale Remote Bit Data
BIGINT1 - - - - - - BIGINT - - -
BLOB 1 2097088000 - - - - BLOB - - -
CHARACTER - - - - - - CHARACTER - - -
CHARACTER - - - - Y - BYTE - - -
CLOB 1 2097088000 - -   - CLOB - - -
DATE - - - - - - DATE - - -
DBCLOB 2 1 64000 - - - - VARGRAPHIC - - -
DECIMAL 1 18/313 0 18/313 - - DECIMAL - - -
DECIMAL4 19 31 0 31 - - FLOAT 8 - -
DOUBLE - - - - - - FLOAT - - -
GRAPHIC - - - - - - GRAPHIC - - -
INTEGER - - - - - - INTEGER - - -
REAL - - - - - - FLOAT 8 - -
SMALLINT - - - - - - SMALLINT - - -
TIME - - - - - - TIME 15 - -
TIMESTAMP 10 10 6 6 - - TIMESTAMP 26 6 -
VARCHAR - - - - - - VARCHAR - - -
VARCHAR - - - - Y - VARBYTE - - -
VARGRAPHIC - - - - - - VARGRAPHIC - - -
Notes:
  1. The BIGINT data type applies to Teradata version 2 release 6 or later.
  2. The Teradata VARGRAPHIC data type can contain only the specified length (1 to 32000) of a DBCLOB data type.
  3. The value 31 applies to Teradata version 2 release 6 or later. The value 18 applies to earlier versions.
  4. This DECIMAL row applies Teradata version 2 release 5 or earlier.