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.