17.10 - CSVSplit 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)
CSVSplit ( ON
  ( SELECT csv_text select_stmt_options )
  [ RETURNS (
      'data' DATASET STORAGE FORMAT CSV
      [ CHARACTER SET [ UNICODE | LATIN ] ]
    )
  ]
  [ USING SCHEMA ( schema ) ]
)

Syntax Elements

csv_text
Any text that evaluates to character data in the CSV format.
select_stmt_options
The allowable or necessary options in Vantage 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.