15.10 - ignore_characters - Teradata Database

Teradata Database Teradata JSON

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1150-151K

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 details on the usage of the name_delimiter and value_delimiter, see SQL Functions, Operators, 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