getUDFOutputSQLXML() - Advanced SQL Engine - Teradata Database

SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
qwr1571437338192.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1147
lifecycle
previous
Product Category
Teradata Vantage™

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.