Functional Description

Teradata Vantageā„¢ XML Data Type

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1140-162K

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.