15.00 - Cast Requirements for Teradata Utilities - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

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.