Publishes one or more XML documents as a stream.
Required Privileges
The XMLPUBLISH_STREAM 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
TD_SYSXML.XMLPUBLISH_STREAM ( queryString, Xslt, documentGroupingSpec )
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. |
documentGroupingSpec | IN | VARCHAR(512) CHARACTER SET UNICODE |
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. |