Use the Column Definition page of the New XML Table Function
wizard
to specify the column name, the data type, and the relative path to
the column
element within the XML document. The specified column name and data
type correspond
to the table format that is returned from the UDF.
- Specify
the path
- Specifies that you will type in the path.
- Import path from XML document
- Specifies
that the path will be imported from an existing XML document.
- Filename
- Specify an existing
file.
- Import path and column definitions
from a file
- Specifies that the paths and column definitions
will be read in from an
existing file that was saved from a prior execution of the wizard.
- Filename
- Specify an existing
file.
- Absolute path to table element
- Type in the absolute path to the table element. The path is from
the root
of the document up to the table element, for example, BookstoreDocument/Books/.
The path cannot be longer than 32,672 characters.
- Relative path to row element
- Type in the path
to the row elements relative to the table element. For
example, /LiteratureBooks where the table path is BookstoreDocument/Books/.