NVP2JSON JSON Function Syntax | Teradata Vantage - NVP2JSON 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ā„¢
[TD_SYSFNLIB.] NVP2JSON (
  NVP_string
  [, name_delimiters, value_delimiters [, ignore_characters] ]
)

Syntax Elements

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