XMLPUBLISH Syntax - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905
TD_SYSXML.XMLPUBLISH (
  queryString,
  Xslt,
  XmlString,
  resultCode
)

Syntax Elements

queryString
The SQL query string whose results are published in XML format.
IN parameter of data type VARCHAR(20000), CHARACTER SET UNICODE.
If queryString is NULL, the XmlString return value is NULL.
Xslt
The XSLT stylesheet representing the mapping from the tabular model of the SQL query result set to the tree model of the XML output.
IN parameter of data type XML.
The Xslt argument is an XML type instance representing a consolidated stylesheet or simply a stylesheet if it does not use stylesheet includes. This stylesheet maps the user query results to the desired XML output.
If Xslt is NULL, the XmlString return value is the XML resulting from canonical publishing.
XmlString
The string representation of XML output.
IN parameter of data type CLOB, CHARACTER SET UNICODE.
resultCode
XMLPUBLISH returns a result code as follows:
  • 0 indicates success
  • -1 indicates failure
OUT parameter of data type INTEGER.