FNC Library Routines That Support the DATASET Type | VantageCloud Lake - FNC Library Routines that Support the DATASET Type - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905
Use the DATASET_HANDLE data type to pass a DATASET type instance as an argument to an external routine or UDF. Similarly, use DATASET_HANDLE to return a DATASET type result from an external routine. DATASET_HANDLE is defined in sqltypes_td.h as follows:
typedef int DATASET_HANDLE;

An FNC call may require that you specify encoding for the schema text being handled. Therefore, the following enum and types are defined in sqltypes_td.h:

typedef enum dataset_schema_encoding_en  {
	datasetSchemaUTF8 = 0,
	datasetSchemaUTF16 = 1
} dataset_schema_encoding_en;
typedef Byte dataset_schema_encoding_t;

The CSV enum field in dataset_storage_et is called DATASET_CSV_EN=1.

The DATASET data type may not be used as an attribute of a structured UDT or as the base type of a Teradata Distinct UDT or ARRAY type.