15.10 - About JSON Type Usage - Teradata Database

Teradata Database Teradata JSON

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1150-151K
The JSON data type can be used similarly to other data types. You can specify the JSON data type in these cases:
  • In table definitions
  • For input parameters and the return type in user-defined functions (UDFs), except for user-defined table operators written in C or C++.
  • For input parameters and the return type in user-defined methods (UDMs)
  • For IN, OUT, and INOUT parameters in external stored procedures
  • For IN, OUT, and INOUT parameters in stored procedures
  • In local variable definitions in stored procedures
  • As an attribute of a structured user-defined type (UDT), but not as the base type of a distinct UDT