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.
| Condition | Return Value |
|---|---|
| String is valid JSON syntax. | 'OK' |
| String is not valid JSON syntax. | 'INVALID: error message' Error message includes cause of syntax failure. |
| String is NULL. | Vantage NULL |