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
ft:locale
en-US
ft:lastEdition
2024-12-13
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
jbg1472252759029
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.