XMLPUBLISH Stored Procedure | XML Data Type | Teradata Vantage - 17.10 - XMLPUBLISH - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - XML Data Type

Advanced SQL Engine
Teradata Database
Release Number
July 2021
Last Update
Content Type
Programming Reference
Publication ID
English (United States)
Last Update

Publishes SQL query results in an XML format specified by the user.

The stored procedure takes the following as input arguments:

  • An SQL query string
  • A mapping stylesheet that will transform the results of the SQL query to the desired XML structure.

    If you do not specify a mapping (you pass NULL as the Xslt argument), the procedure returns the canonical XML representation as output.

Recommendation: Use this stored procedure in the following cases:

  • The size of the documents being published is small
  • The use of Teradata specific instructions, like teradata_group, is not required
    Teradata specific instructions are ignored by XMLPUBLISH.
  • You need to publish multiple documents

For other cases, use the XMLPUBLISH_STREAM stored procedure instead.

Required Privileges

The XMLPUBLISH stored procedure is created under the user TD_SYSXML.

The user invoking this stored procedure must have the following privileges:
  • SELECT privilege on the staging table
  • GRANT ALL (insert/update/delete/upsert) on the target tables

Result Type

The result XmlString is a string representation of the XML to be published.

XMLPUBLISH returns a resultCode value:
  • 0 indicates that the procedure executed successfully.
  • -1 indicates that the procedure resulted in an error.