16.20 - getUDFOutputSQLXML() - 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

Retrieves an SQLXML object representing the return value of a Java UDF that returns an XML value.

Syntax

public static java.sql.SQLXML getUDFOutputSQLXML()
                         throws SQLException

Return Value

The com.teradata.fnc.SQLXML object that represents the return XML value of the Java UDF.

Usage Notes

This method can only be called from a scalar or aggregate Java UDF. If called from an aggregate Java UDF, it may only be called in the Phase.AGR_FINAL execution phase.

Exceptions

Throws SQLException if a database access error occurs. A database specific error code “9752 (ERRUDFJAVAXML)<Failed to retrieve XML object>” is returned.