FNC_GetDatasetInputLob Function | C Library Functions | Teradata Vantage - 17.10 - FNC_GetDatasetInputLob - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL External Routine Programming

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

This routine allows users to read DATASET data that is stored as a LOB using the LOB FNC routines.


FNC_GetDatasetInputLob( DATASET_HANDLE   datasetHandle,
                        LOB_LOCATOR*     instance  )

Syntax Elements

A handle to a DATASET data type instance that is defined to be an input parameter to an external routine.
A pointer to a LOB_LOCATOR which will be used to read the LOB data of a DATASET instance.

Usage Notes

Use FNC_GetDatasetInputLob only when the DATASET data is stored as a LOB. If FNC_GetDatasetInfo returns dataLob > 0, you can use FNC_GetDatasetInputLob; otherwise, you should use FNC_GetInternalValue instead.

For Avro instances, this routine returns a LOB_LOCATOR which allows a user to access a buffer that contains the UTF-8 encoded schema, null-terminated, followed by the binary-encoded Avro value. This is equivalent to the transform format.

If the DATASET data is a CSV value, the value does not include any optional schema.