JSON_COMPOSE Function Examples | Teradata Vantage - Setting Up the JSON_COMPOSE Basic Examples - Advanced SQL Engine - Teradata Database

JSON Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
uwa1591040057999.ditamap
dita:ditavalPath
uwa1591040057999.ditaval
dita:id
B035-1150
lifecycle
previous
Product Category
Teradata Vantageā„¢

Create and populate table(s) to use in subsequent example(s).

CREATE TABLE emp_table (
   empID INTEGER,
   company VARCHAR(50), 
   empName VARCHAR(20),
   empAge INTEGER);

INSERT INTO emp_table(1, 'Teradata', 'Cameron', 24); 
INSERT INTO emp_table(2, 'Teradata', 'Justin', 34); 
INSERT INTO emp_table(3, 'Apple', 'Someone', 34);