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

SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
qwr1571437338192.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1147
lifecycle
previous
Product Category
Teradata Vantage™

Purpose

Determines whether a UDT supports serialization and deserialization.

Syntax

int
FNC_UdtSerializeSupported(UDT_HANDLE  udt)
UDT_HANDLE udt
the handle of the UDT.

Return Value

  • 1 : the UDT supports serialization and deserialization
  • 0 : the UDT does not support serialization and deserialization

Usage Notes

The following UDTs support the serialize/deserialize interface. The formats that each UDT will use to serialize and deserialize data are as follows:

UDT Format
ST_Geometry The serialized format is opaque. It is designed to be compact and efficient to serialize and deserialize.
XML The serialized format is opaque. It is designed to be compact and efficient to serialize and deserialize.
JSON The serialized format is the text string that represents the JSON data, and it is equivalent to the transformed value (FromSQL/ToSQL) of the JSON data type.