16.20 - Functional Description - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ XML Data Type

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
Release Date
March 2019
Content Type
Programming Reference
Publication ID
English (United States)

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.