CreateDATASET is used to create DATASET data type instances. The instances are composed of self-describing data where the schema and data arrive separately. If the data is already with its schema, you do not need CreateDATASET to create an instance from the data.
- Schema: A schema conforming to the specifications. If the Schema parameter is null, it is assumed 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.
- Data: A BYTE/VARBYTE/BLOB containing the binary-encoded self-describing data value. Data can be specified in any way Teradata Database currently 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.
- Storage format: Specify the name of the storage format. Any other value, including a null or omitted value, are invalid.