TD_SYSXML.XMLPUBLISH_STREAM (
queryString,
Xslt,
documentGroupingSpec
)
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 will be 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 should map the user query results to the desired XML output.
- If Xslt is NULL, the XmlString return value is the XML resulting from canonical publishing.
- documentGroupingSpec
- A string on the basis of which the query results are organized into XML documents. The string format is a comma-separated list of column names.
- IN parameter of data type VARCHAR(512), CHARACTER SET UNICODE.
- If documentGroupingSpec is NULL, the XmlString column in the result set represents a single document representing the query results in XML format. If documentGroupingSpec is not NULL, the XmlString column represents multiple documents, with the documents separated by a NULL in the XmlString column.