FNC_SetXML Function | C Library Functions | Teradata Vantage - FNC_SetXML - 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ā„¢

Set the value of an XML type.

Syntax

void
FNC_SetXML(XML_HANDLE      xmlHandle,
           byte          *xmlBuffer,
           int             xmlSize)

Syntax Elements

xmlHandle
A handle to an XML type that is defined to be a return value for a UDF/UDM or an INOUT/OUT parameter to an external stored procedure.
xmlBuffer
A pointer to the XML value to be set.
xmlSize
The total size in bytes of the XML value.

Usage Notes

FNC_SetXML is used to set an XML return value or OUT parameter value using a memory buffer.

The XML handle xmlHandle is passed as input along with a pointer to the XML value. The XML value must be in the UNICODE character set.

Note that the XML value that is passed to this routine must contain well-formed XML data, otherwise you will get an error.

FNC_SetXML can only be called for inline XML values, that is XML values that are less than 64K, otherwise you will get an error.