Inserting UDTs with Teradata MultiLoad - MultiLoad

Teradata® MultiLoad Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
MultiLoad
Release Number
20.00
Published
October 2023
Language
English (United States)
Last Update
2024-03-18
dita:mapPath
lji1691576359330.ditamap
dita:ditavalPath
kju1619195148891.ditaval
dita:id
sga1478609868891
Product Category
Teradata Tools and Utilities

Teradata MultiLoad can insert values into tables containing UDT columns in the same manner as is done for other tables.

  • Input Records – The input records to Teradata MultiLoad must have the column data for UDT columns in its external type format. When the input record format is defined, the external type must be used for the UDT columns.
  • Table Command – If the “TABLE” command is used to define the input record format, and columns in the referenced TABLEs contain UDTs, then the external types corresponding to the UDTs will be used in the input record format for those columns.