JSON_CHECK

Teradata Vantageā„¢ JSON Data Type

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1150-162K

Purpose

The JSON_CHECK function checks a string for valid JSON syntax and provides an informative error message about the cause of the syntax failure if the string is invalid.

Syntax



TD_SYSFNLIB
The name of the database where the function is located.
'{string}'
The string to be tested for compliance to JSON syntax.
CHAR, VARCHAR, and CLOB are the allowed input types.
LATIN and UNICODE are allowed for all data types.
A maximum of 8388096 UNICODE characters or 16776192 LATIN characters may be passed in for validation.

Return Value

  • 'OK', if the string is valid JSON syntax.
  • 'INVALID: error message', if the string is not valid JSON syntax. The error message provides an informative message about the cause of the syntax failure.
  • A Teradata NULL, if the input string is NULL.

Usage Notes

This function only tests data for compliance with JSON syntax. It does not create a JSON instance.

You can use this function to validate JSON data before loading it. This can save time when loading a large amount of JSON data by preventing the rollback of an entire transaction in the event of a JSON syntax error. The function also provides the necessary information to fix any syntax errors that may be present before you load the data.

You cannot use JSON_CHECK to validate JSON data that is stored in one of the binary formats. To validate BSON data, use the BSON_CHECK function.