XML Structure Tab: Combined Node Column

Applies to: Both marshalling data to XML and unmarshalling data from XML to an RDB

Available: For mapped nodes only. When you have mapped an element, or at least one of the element's descendants is mapped to a DB column, an expression, a constant, or just added to the mapping file. Clicking in this column opens the Combine Node Wizard that allows you to set an element to use as a combined node.

Possible Values:

	Not currently set. The default setting: you have not set the field to combine multiple occurrences of the node.
	If marshalling, you have selected to combine multiple occurrences of this XML node in the XML output file. If unmarshalling, you are requesting the winAllora engine to assume there are multiple occurrences of this column in the database.
	You have selected to combine occurrences on a child XML node and this node has inherited the Combine setting. You cannot remove this setting on a node unless you remove the setting for the sub-element that caused the inheritance.
	You have customized the Combine setting by also setting options in the Combine Key, Group at Node or Eliminate Duplicates columns.
	You have selected to combine occurrences on a child XML node and this node has inherited the Combine setting.

Explanation

Summary | Examples

When you check this column, the default behavior when no other column values have been set is:

In marshalling, the engine compares the element and all its attributes to other elements/attributes in the results to determine if the node can be combined.
In unmarshalling, this depends on the setting in the Project Properties Unmarshal tab "Uncombine Input XML Nodes Using Method" field.

When marshalling, you can also set custom values in the Combine Key column to change the way an element is compared. This is useful both for performance and for using a child node or the attribute of a child node in the comparison.

Examples

Summary | Explanation

	Marshal with Combine Project	Overview of the project used in examples below.
1.	Marshal Without Combine	No settings have been made in the XML Structure tab
2.	Marshal with Combine	XML output combines all PurchaseOrder nodes that have a matching value for the OrderID node.
3.	Marshal with Combine and Group	XML output groups all matching elements (LineItem) together
4.	Marshal with Combine and Order By	XML output contains records retrieved from the database using an ORDER BY clause
5.	Marshal with Optimized Combine	XML output generated using the Optimized Combine feature in the XML Structure tab.

XML Structure Tab: Combined Node Column

Explanation

Examples

See Also