This function is only available when connected to a Teradata database.
The following JSON procedures are SQL stored procedures that use any number of JSON instances to populate existing tables, providing a flexible form of loading data from the JSON format into a relational model. The batch shredding procedures map into a number of successive calls to JSON_TABLE to create a conglomerate temporary table, the values of which can be assigned to existing tables.
Two shred procedures are provided; however, the only difference between them is the character set of the data, listed below.
|JSON_SHRED_BATCH||Operates on LATIN character set data.|
|JSON_SHRED_BATCH_U||Operates on UNICODE character set data.|