DATASET Constructor Syntax - Advanced SQL Engine - Teradata Database

DATASET Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
amv1590702100517.ditamap
dita:ditavalPath
amv1590702100517.ditaval
dita:id
B035-1198
lifecycle
previous
Product Category
Teradata Vantageā„¢
new DATASET (
  schema_expression,
  DATASET_expression,
  { AVRO | CSV [, { LATIN | UNICODE } ] }
)

Syntax Elements

schema_expression
Any expression that evaluates to a Teradata VARCHAR or VARBYTE conforming to the Avro or CSV schema specifications.
DATASET_expression
The CSV or Avro data value. If the constructor is for a CSV value, the value is a VARCHAR or CLOB in either the LATIN or UNICODE character set. If the constructor is for an Avro value, this value is VARBYTE or BLOB.
AVRO
CSV
The storage format of the new DATASET instance, either CSV or Avro.
LATIN
UNICODE
The character set of the returned CSV DATASET value, either LATIN or UNICODE. You can specify the character set only for the CSV storage format. If this parameter is omitted for a CSV value, the return CSV value is created in the current server character set.