FNC_GetDatasetResultLob Function | C Library Functions | Teradata Vantage - FNC_GetDatasetResultLob - Analytics Database - Teradata Vantage

SQL External Routine Programming

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
iiv1628111441820.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1147
lifecycle
latest
Product Category
Teradata Vantageā„¢

This routine allows DATASET data to be written to a LOB associated with a DATASET instance.

Syntax

void
FNC_GetDatasetResultLob( DATASET_HANDLE        datasetHandle,
                         LOB_RESULT_LOCATOR*   instance  )

Syntax Elements

datasetHandle
A handle to a DATASET data type instance that is defined to be an input parameter to an external routine.
instance
A pointer to a LOB_RESULT_LOCATOR to be used to write the LOB data of a DATASET instance.

Usage Notes

Use FNC_GetDatasetResultLob only when the DATASET data will be stored as a LOB. If FNC_GetDatasetInfo returns dataLob > 0, you can use FNC_GetDatasetResultLob; otherwise, you should use FNC_SetInternalValue instead.

The LOB_RESULT_LOCATOR obtained may be used with all LOB FNC routines that allow the user to write to this LOB.

For Avro instances, this routine returns a LOB_RESULT_LOCATOR which allows a user to write the UTF-8 encoded schema, null-terminated, followed by the binary-encoded Avro value to a buffer. This is equivalent to the transform format. Failure to write the data in this format results in an error.

For CSV values, the value is written to the result LOB, but does not include any optional schema.