XMLPUBLISH

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

Purpose

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

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

Syntax



Parameter Name Parameter Type Data Type Description
queryString IN VARCHAR(20000)

CHARACTER SET UNICODE

The SQL query string whose results are published in XML format.
Xslt IN XML The XSLT stylesheet representing the mapping from the tabular model of the SQL query result set to the tree model of the XML output.
XmlString OUT CLOB

CHARACTER SET UNICODE

The string representation of XML output.
resultCode OUT INTEGER XMLPUBLISH returns a result code as follows:
  • 0 indicates success
  • -1 indicates failure