JSON_SHRED_BATCH and JSON_SHRED_BATCH_U are SQL stored procedures that use JSON instances to populate existing tables, providing a flexible form of loading data from the JSON format into a relational model. The only difference between these two shred procedures is the character set of the data. This topic explains only JSON_SHRED_BATCH (the version that operates on LATIN character set data), but the explanation applies equally to JSON_SHRED_BATCH_U (the UNICODE version).
The batch shredding procedures map into successive calls to JSON_TABLE to create a conglomerate temporary table, the values of which can be assigned to existing tables.
Condition | Return Value |
---|---|
Shred operation succeeds. | 0 |
Shred operation fails. | Nonzero value indicating specific error condition and appropriate error message |