[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