Parameters - Advanced SQL Engine - Teradata Database

XML Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
amr1556233250442.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1140
lifecycle
previous
Product Category
Teradata Vantageā„¢
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