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.