XML Type Usage - Teradata Vantage NewSQL Engine - 16.20

Teradata Vantageā„¢ XML Data Type

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1140-162K
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 .