XMLPUBLISH_STREAM

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 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



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.