15.10 - Migrating Data to the JSON Type - Teradata Database

Teradata Database Teradata JSON

Product
Teradata Database
Release Number
15.10
Published
December 2015
Language
English (United States)
Last Update
2018-06-05
dita:mapPath
TeradataJSON_15_10.ditamap
dita:ditavalPath
ft:empty
You can migrate data to the JSON type following these steps:
  1. (Optional) If converting from XML to JSON, the XML data must be stored in CLOB or VARCHAR columns.
  2. Verify that the intended JSON data is well-formed and conforms to the rules of JSON formatting.
  3. Create new versions of the tables using the JSON type for columns that will hold the JSON data.
  4. Insert the JSON text (for example, the JSON constructor or string) into the JSON columns.JSON cannot be loaded with FastLoad, MultiLoad, or FastExport due to restrictions on all LOB types.