CreateDATASET (
schema_expression,
data_expression,
{ AVRO | CSV [ , { LATIN | UNICODE } ] }
)
Syntax Elements
- schema_expression
- Any expression that evaluates to the following Teradata data types conforming to the schema specifications:
- CHAR
- VARCHAR
- CLOB
- JSON
- BYTE
- VARBYTE
- BLOB
- A null Schema parameter indicates that the instance is being loaded into a column with a column-based schema. If not, and you use the instance without providing a schema (for example, writing the instance out to a table, or searching using dot notation), an error occurs.
- The schema data is provided as a CHAR/VARCHAR/CLOB in either the LATIN or UNICODE character set, or as a BYTE/VARBYTE/BLOB representing the UTF8 encoding of the schema. The schemas provided as BYTE/VARBYTE/BLOB data are not null-terminated.
CLOB LATIN/UTF16 is only supported on the Block File System on the primary cluster. It is not available for the Object File System.
- data_expression
- Any expression that evaluates to Teradata BYTE/VARBYTE/BLOB/CLOB data.
- A BYTE/VARBYTE/BLOB containing the binary-encoded self-describing data value. Data can be specified in any way Vantage allows for function parameters. If validation is enabled, and a null value does not complete the specified schema, an error occurs. Otherwise, the data is accepted.
- AVRO
- CSV
- Specify the name of the storage format. Any other value, including a null or omitted value, are invalid.
- LATIN
- UNICODE
- The character set of the created 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 CSV value is created in the default server character set.