Cast Requirements for Teradata Utilities | CREATE CAST | Teradata Vantage - Cast Requirements for Teradata Utilities - Analytics Database - Teradata Vantage

SQL Data Definition Language Detailed Topics

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1184
lifecycle
latest
Product Category
Teradata Vantage™
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.