JSON Methods (Teradata Database) - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.5
Published
February 2018
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
qhj1503087326201.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software

The following table lists the available JSON methods, and a description of their purpose.

XML, JSON etc.: JSON Methods
Method Description
JSON Constructor (Empty) The JSON Constructor (Empty) allocates an unpopulated JSON type instance.
JSON Constructor The JSON Constructor allocates a JSON type instance. The constructor can be used without arguments (default constructor) or with arguments to set the value and the character set of the JSON instance. The resulting JSON instance can be used to insert a JSON type into a column or as a JSON type argument to a function or method.
COMBINE(x) The Combine method takes two JSON documents (specified by the JSON expression), combines them, and returns a JSON document structured as an array or structured as an object.
COMBINE(x,y) The Combine method takes two JSON documents (specified by the JSON expression), combines them, and returns a JSON document structured as an array or structured as an object.
EXISTVALUE The ExistValue method determines if a name represented by a JSONPath-formatted string exists in a JSON instance.
JSONEXTRACT The JSONExtract method operates on a JSON instance, to extract data identified by the JSONPath formatted string. If one or more entities are found, the result of this method is a JSON array composed of the values found; otherwise, NULL is returned.
JSONEXTRACTVALUE The JSONExtractValue and JSONExtractLargeValue methods retrieve the text representation of the value of an entity in a JSON instance. JSONExtractLargeValue takes the same input parameters and operates the same as JSONExtractValue; however, the return type and size are different.
JSONEXTRACTLARGEVALUE See JSONEXTRACTVALUE above.