- 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 .