16.20 - Parameters - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ XML Data Type

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1140-162K
Language
English (United States)
Parameter Name Parameter Type Data Type Description
queryString IN VARCHAR(20000)

CHARACTER SET UNICODE

The SQL query string which when evaluated returns a result set with two columns: an ID column and a column with the XML documents to be shredded.
annotatedSchema IN XML The annotated W3C XML schema that provides the mapping from the XML documents to be shredded to the target table schema.
externalContext IN VARCHAR(512)

CHARACTER SET UNICODE

A comma separated list of name=value pairs that parameterize the shredding operation. These values override configuration parameters like defaultDatabase which are specified in the annotated schema mapping.
resultCode OUT INTEGER A return code where:
  • 0 = success
  • 1 = failure