15.10 - Migrating Data to the JSON Type - Teradata Database

Teradata Database Teradata JSON

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1150-151K
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.