Input
- xmlrelation_input, as in XMLRelation Example 1: OutputType ('fulldata')
SQL Call
This call specifies the default Output argument value.
SELECT * FROM XMLRelation (
ON xmlrelation_input
USING
TextColumn ('xmldocument')
DocIDColumns ('xid')
MaxDepth (3)
OutputType ('fullpath')
) AS dt ORDER BY 1,2;
Output
The output table shows the ID for each node in a separate column.
xid | out_nodeid | element | attributes | value_col | d0id | d1id | d2id | d3id |
---|---|---|---|---|---|---|---|---|
1 | 1 | School | name=UCLA | 1 | ||||
1 | 2 | Dept | name=EE | 1 | 2 | |||
1 | 3 | Class | A=grad, B=undergrad | 1 | 2 | 3 | ||
1 | 4 | Student | Harry | 1 | 2 | 3 | 4 | |
1 | 5 | Grade | A+ | 1 | 2 | 3 | 5 |