7.00.02 - Output ('fulldata') - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)
Last Update
2018-04-17
XMLRelation Output Table Schema, Output ('fulldata')
Column Data Type Description
docid_column INTEGER or VARCHAR Identifier of the XML document. Cannot be NULL.
out_nodeid INTEGER Identifier of extracted node, unique within the XML document. Cannot be NULL.
DnElement VARCHAR Name of node at depth n. The table has a column for each n in the range [0, max_depth). The node at depth 0 is the root.
DnAttributes VARCHAR Attributes of node at depth n. This value has this form:

attributename=value[delimiter value…]

The table has a column for each n in the range [0, max_depth).

DnValue VARCHAR Value (text content) of node at depth n. The table has a column for each n in the range [0, max_depth).
DnID INTEGER Identifier of node at depth n (its out_nodeid).
accumulate_column Same as in input table Column copied from the input table.

The columns DnElement, DnAttributes, DnValue, and DnID contain information about the node at depth n, and the columns DiElement, DiAttributes, DiValue, and DiID, where i is in the range [0, n), contain information about its ancestors.