ExistValue JSON Method Syntax | Teradata Vantage - ExistValue Syntax - Advanced SQL Engine - Teradata Database

JSON Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
gzn1554761068186.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1150
lifecycle
previous
Product Category
Teradata Vantageā„¢
JSON_expr.ExistValue (JSONPath_expr)

Syntax Elements

JSON_expr
An expression that evaluates to a JSON data type.
JSONPath_expr
A name in JSONPath syntax.
The name can be either UNICODE or LATIN, depending on the character set of the JSON type that invoked this method. If the parameter character set does not match the character set of the JSON type, Vantage attempts to translate the parameter character set to the correct character set.
JSONPath_expr cannot be NULL. If the expression is NULL an error is reported.