16.20 - Syntax Elements - Teradata Database - Teradata Vantage NewSQL Engine
Teradata Vantage™ DATASET Data Type
- Product
- Teradata Database
- Teradata Vantage NewSQL Engine
- Release Number
- 16.20
- Published
- March 2019
- Language
- English (United States)
- Last Update
- 2019-05-02
- dita:mapPath
- pgs1512082344257.ditamap
- dita:ditavalPath
- TD_DBS_16_20_Update1.ditaval
-
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.