Migrate Data to the XML Type | Teradata Vantage - 17.10 - Migrating Data to the XML Type - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - XML Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1140-171K
Language
English (United States)
To migrate XML data stored in VARCHAR or CLOB columns to equivalent schemas with XML type columns, do the following:
  1. Verify the XML data is well-formed and conforms to rules of XML formatting.
  2. Create new versions of the tables using XML type for columns that will hold the XML data.
  3. Insert the XML text into the XML columns using the NEW XML operator or the CREATEXML function.