16.20 - Cast Requirements for Teradata Utilities - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1184-162K
Language
English (United States)
Some Teradata utilities require you to define casts to permit them to process UDT data. The following list explains what those requirements are:
  • Database utilities

    None of the platform-based utilities have transform requirements.

    The USING modifier requires you set up implicit casts for casting a predefined external data type to a UDT. See Teradata Vantage™ SQL Data Manipulation Language , B035-1146 for details.

  • Teradata Tools and Utilities
    The following table explains the casting requirements for various Teradata Tools and Utilities:
    Utility Cast Requirements
    Archive/Recovery None
    FastExport None
    FastLoad None
    MultiLoad None
    Teradata Parallel Data Pump (TPump) Implicit cast from a predefined external data type to a UDT.
    Teradata Parallel Transporter:
    • UPDATE
    • LOAD
    • EXPORT
    None
    Teradata Parallel Transporter STREAMS Implicit cast from a predefined external data type to a UDT.