Syntax Elements - Teradata Vantage NewSQL Engine - 16.20

Teradata Vantageā„¢ DATASET Data Type

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1198-162K
csv_text
Any text that evaluates to character data in the CSV format.
select_stmt_options
The allowable or necessary options in Teradata Database for a SQL SELECT statement.
RETURNS
Specifies the output data type or length. The default is to return a maximum length CSV, so omit RETURNS for this output.
DATASET STORAGE FORMAT CSV
Returns data that uses the CSV storage format. The default returns a CSV of maximum length, so the RETURNS clause may be omitted if this is the desired output.
CHARACTER SET
The character set specified by DATASET STORAGE FORMAT CSV. The options include UNICODE or LATIN.
SCHEMA
Specify SCHEMA to explicitly define the published data structure. Use the clause with a character string representing an ad-hoc schema specification; any other value results in an error. If an ad-hoc schema is specified, the structure must conform to the CSV format rules. If the clause is not specified, the input CSV data is assumed to conform to the defaults.