Cast Requirements for Teradata Utilities | CREATE CAST | Teradata Vantage - 17.10 - Cast Requirements for Teradata Utilities - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1184-171K
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 has 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.

  • Teradata Tools and Utilities
    The following table explains the casting requirements for various Teradata Tools and Utilities:
    Utility Cast Requirements
    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.