15.00 - Cast Requirements for Teradata Utilities - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

Cast Requirements for Teradata Utilities

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 SQL Data Manipulation Language 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.