Stored Procedures with JSON Type Local Variables

Teradata Vantageā„¢ JSON Data Type

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1150-162K
You can create a stored procedure containing one or more local variables that are JSON data type. You can use the DEFAULT clause with the declaration of these local variables:
  • DEFAULT NULL
  • DEFAULT value

If you specify DEFAULT value, you can use a JSON constructor expression to initialize the local variable. See About JSON Type Constructor.

You can use the stored procedure semantics, including cursors, to access a particular value, name/value pair, or nested documents structured as objects or arrays. You can use this with the JSON methods and functions that allow JSONPath request syntax for access to specific portions of a JSON instance.