XSLT_SHRED Syntax - Advanced SQL Engine - Teradata Database

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.