XML publishing is the process of formatting the results of an SQL query as XML. SQL query results are mapped to an XML format according to a mapping specification provided by the user.
To publish XML from Teradata Database, perform the following tasks:
1 Define the SQL query whose output you want to publish as XML.
2 Define a mapping from the SQL query results to the desired XML structure.
3 Store the mapping so that it can be easily referenced, for example, in a stylesheet repository table.
4 Call one of the XML publishing stored procedures (XMLPUBLISH or XMLPUBLISH_STREAM) with the following arguments:
You define the XML publishing mapping as an XSLT stylesheet that defines a transformation from the canonical representation of the query result to the desired XML output structure. For details on defining a mapping for XML publishing, see “Mapping SQL Query Results to an XML Format” on page 102.
If you pass NULL as the Xslt (mapping definition) argument to XMLPUBLISH or XMLPUBLISH_STREAM, the stored procedures will return the canonical XML representation as output. For details about the canonical XML representation, see “Canonical XML Publishing” on page 102.