17.10 - CSV_TO_JSON Syntax - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - DATASET Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1198-171K
Language
English (United States)
CSV_TO_JSON ( ON
  ( SELECT CSV_expression select_stmt_options )
  [ USING { SCHEMA ( schema ) | AGGREGATE ( {'Y'|'N'} ) } ]
)

Syntax Elements

CSV_expression
Any expression that evaluates to character data in the CSV format or a DATASET STORAGE FORMAT CSV value.
select_stmt_options
The select_stmt_options are the allowable or necessary options in Vantage for a SQL SELECT statement.
USING
Variables used as input to the SQL statement specified by select_stmt_options.
schema
The CSV schema.
AGGREGATE
Specify AGGREGATE for the output instances to be composed of one row of input data.