The XML input format supports the following parameters:
rootXPath | ||
Values: | XPath query | |
Default: | not specified | |
Description: | XPath query of document node(s) to be considered root node(s). | |
Details: | The node(s) selected by the specified
XPath replace the document root node as the starting node(s) from
which all the document nodes are visited. Note: This parameter is ignored for XML documents whose filename or URL has been specified together with an optional XPath in the from-entity. Note: The XPath specified for this parameter is case-sensitive. If an XPath is specified containing non-existing node or attribute names, or containing node or attribute names with the wrong capitalization, no root node is selected and an error is returned. |
|
Example: | -rootXPath:/World/Continent/Country | |
fMode | ||
Values: | Branch | Tree | Node | Auto | |
Default: | Auto | |
Description: | Algorithm to use when visiting the document nodes. | |
Details: | For information on the "Branch",
"Tree", and "Node" visit algorithms see XML Input Format Fields. The "Auto" value instructs the XML input format to determine automatically the best algorithm after inspecting the structure of the input document(s). |
|
Example: | -fMode:Tree | |
iTsFormat | ||
Values: | timestamp format | |
Default: | yyyy-MM-dd?hh:mm:ss | |
Description: | Format of timestamp values in the document. | |
Details: | This parameter specifies the date and/or time format used in the document being parsed. Values of nodes or attributes matching the specified format are returned as values of the TIMESTAMP data type. For more information on date and time formats, see Timestamp Format Specifiers. | |
Example: | -iTsFormat:"MMM dd, yyyy" | |
dtNodes | ||
Values: | number of leaf nodes (number) | |
Default: | -1 | |
Description: | Number of leaf nodes to be examined when determining the document structure. | |
Details: | In order to determine the input
document structure, the XML input format initially examines the
nodes found along the paths from the root node or from the node(s)
selected by the user-supplied root XPath to the first n leaf
nodes, where n is the value specified for this
parameter. Specifying -1 causes the XML input format to examine all the nodes in the input document. |
|
Example: | -dtNodes:50 | |
fNames | ||
Values: | Compact | XPath | |
Default: | Compact | |
Description: | Field naming schema. | |
Details: | Specifying "Compact" causes the XML
input format to create field names using the names of the
corresponding nodes or attributes. If a field name is not unique, a
sequential number is appended to the name to render it unique. Example field names in the "Compact" mode are: ContinentName CountryName City PopulationSpecifying "XPath" causes the XML input format to create field names using the XPath queries for the corresponding nodes or attributes. Example field names in the "XPath" mode are: /World/Continent/@ContinentName /World/Continent/Country/@CountryName /World/Continent/Country/City /World/Continent/Country/City/@Population |
|
Example: | -fNames:XPath | |
© 2004 Microsoft Corporation. All rights reserved.