7.00.02 - Output ('fullpath') - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)
XMLRelation Output Table Schema, Output ('fullpath')
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.
Element VARCHAR Name of node. Cannot be NULL.
Attributes VARCHAR Attributes of node. This value has this form:

attributename=value[delimiter value…]

Value VARCHAR Value (text content) of node.
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.