17.10 - XSLT_SHRED Syntax - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - XML Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1140-171K
Language
English (United States)
TD_SYSXML.XSLT_SHRED (
  xmlDoc,
  xsltMapping,
  externalContext,
  resultCode
)

Syntax Elements

xmlDoc
The XML document that will be shredded to the target table.
IN parameter of data type XML.
An error is reported if this parameter is NULL.
xsltMapping
An XSLT stylesheet provides the mapping from the XML document elements to be shredded to the target table columns.
IN parameter of data type XML.
externalContext
A semicolon separated list of name=value pairs that parameterize the shredding operation. These values override configuration parameters, such as defaultDatabase, that are specified in the annotated stylesheet mapping.
IN parameter of data type VARCHAR(512), CHARACTER SET UNICODE.
resultCode
A return code where:
  • 0 = success
  • 1 = failure
OUT parameter of data type INTEGER.