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.
CreateDATASET has three required parameters:
- 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.