New XML Type Instances | XML Data Type | Teradata Vantage - 17.10 - XML Type Usage - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - XML Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1140-171K
Language
English (United States)
You can use the XML type the same way as other SQL data types. For example, you can specify the XML type as follows:
  • In table definitions
  • As part of a structured UDT
  • As parameters and return types for UDFs written in C, C++, or Java. This includes scalar and aggregate UDFs, table functions, and table operators.
  • As IN, INOUT, and OUT parameters of stored procedures and external stored procedures written in C, C++, or Java.
  • As parameters and return types for UDMs written in C or C++.

XML FNC functions and Java classes and methods are provided to enable a UDF, UDM, or external stored procedure to access and set the value of an XML parameter, or to get information about the XML type parameter. For information about these functions and methods, see Teradata Vantage™ - SQL External Routine Programming, B035-1147.