16.20 - FNC_UdtSerializeSupported - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
April 2020
Content Type
Programming Reference
Publication ID
B035-1147-162K
Language
English (United States)

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.