Parameters - Teradata Vantage NewSQL Engine - 16.20

Teradata Vantageā„¢ XML Data Type

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1140-162K
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