Functional Description - 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ā„¢

The shredding procedure processes in a streaming fashion (the whole document is not loaded into memory all at once) each of the documents returned by evaluating the SQL query specified by queryString. The annotated schema is used to extract the values of interest from each of the documents and the target tables are updated using these values. During this process, if an externalContext is specified, any configuration values specified are used to override equivalent parameters in the annotated schema mapping.