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

Teradata Vantageā„¢ - XML Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1140-171K
Language
English (United States)

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:
  • EXECUTE PROCEDURE on TD_SYSXML
  • 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.