SQL Procedures Using JSON Type Example | JSON Data Type | Teradata Vantage - Example: Stored Procedures with JSON Type Parameters - Advanced SQL Engine - Teradata Database

JSON Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
gzn1554761068186.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1150
lifecycle
previous
Product Category
Teradata Vantageā„¢
The following statement defines a stored procedure with an IN parameter that is a JSON type with a maximum length of 100.
CREATE PROCEDURE my_tdsp1 (IN p1 JSON(100))
...
;
The following statement defines a stored procedure with an OUT parameter that is a JSON type with a maximum length of 100.
REPLACE PROCEDURE my_tdsp2 (IN p1 INTEGER, OUT p2 JSON(100))
...
;