NVP2JSON

Teradata Vantageā„¢ JSON Data Type

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

Purpose

A function to convert a string of name-value pairs to a JSON object.

Syntax



NVP_string
A string in the name/value pair format.
name_delimiters

Optional.

One or more delimiters of one or more character each. This is the delimiter used between separate name/value pairs.

value_delimiters

Optional.

One or more delimiters of one or more characters each. The delimiter is used between names and corresponding values.

ignore_characters

Optional.

One or more characters that are removed from the beginning of Names of the NVP as the names are converted to JSON keys.

For more information on the usage of the name_delimiters and value_delimiters, see Teradata Vantageā„¢ SQL Functions, Expressions, and Predicates, B035-1145. This function has the same behavior for those arguments.

The expressions passed to this function must have the following data types:
  • NVP_string = CHAR, VARCHAR, CLOB : LATIN or UNICODE
  • name_delimiters = CHAR, VARCHAR, CLOB : LATIN or UNICODE
  • value_delimiters = CHAR, VARCHAR, CLOB : LATIN or UNICODE
  • ignore_characters = CHAR, VARCHAR, CLOB : LATIN or UNICODE