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.