15.10 - ExistValue - Teradata Database

Teradata Database Teradata JSON

Product
Teradata Database
Release Number
15.10
Published
December 2015
Language
English (United States)
Last Update
2018-06-05
dita:mapPath
TeradataJSON_15_10.ditamap
dita:ditavalPath
ft:empty

Purpose

The ExistValue method determines if a name represented by a JSONPath-formatted string exists in a JSON instance.

Syntax



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, Teradata 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.

Functional Description

ExistValue determines if the name specified by JSONPath_expr exists in the JSON instance specified by JSON_expr.

Return Value

  • 1, if the specified name is found at least once in the JSON instance.
  • 0, if the name is not found.
  • NULL, if the JSON_expr argument is null.