15.10 - Stored Procedures with JSON Type Local Variables - Teradata Database

Teradata Database Teradata JSON

Product
Teradata Database
Release Number
15.10
Published
December 2015
Language
English (United States)
Last Update
2018-06-05
dita:mapPath
TeradataJSON_15_10.ditamap
dita:ditavalPath
ft:empty
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.