XML Structure Tab

Set ORDER BY Sequence
Opens the Set Database Column/Expression Sequence dialog, allowing you to set the order of nodes in the output file.

Select Sort/ORDER BY Method
A drop-down menu that allows you to choose how you want nodes sorted in an XML output file.

Auto-set Combined Nodes from an XML File
Allows you to automatically make settings in the XML Structure tab based on an existing XML file.

Column

Description

Unique Key

Displays a key icon next to nodes which are mapped to a database column that:

• Is a primary key in the database and has the Is Unique unmarshal attribute set to true (default setting)

• Or, has the Is Unique unmarshal attribute set to true

XML Schema

Displays the XML schema for the project, as in the Mappings tab. Click the + and - to expand and contract XML nodes.

Order By

Add Mapped Column/Expression to ORDER BY Clause

Allows you to order nodes in XML output (marshalling) by node value. Visible only when Select Sort/ORDER BY Method option is set to Sort XML Output Records Using ORDER BY. Adds the node to an ORDER BY clause in the SELECT statement automatically generated during marshalling.

Sort Children

Sort Order for Child Nodes in Marshal Output

Allows you to order nodes in XML output (marshalling) by node tag name (then node value and attributes). Visible only when Select Sort/ORDER BY Method option is set to Sort XML Output Nodes in Memory. Uses the result set returned from the database to sort nodes by tag name.

Combined Node

Combine Duplicate XML Records at Node

Allows you to combine duplicate occurrences of a node during marshalling or interpret combined nodes during unmarshalling. In marshalling, aggregates children of the selected node under a single occurrence of the node. In unmarshalling, behavior depends on the setting in the Unmarshal Settings dialog "Expand XML Nodes Method" field.

Combine Key

Set Node as Key to Compare Combined Nodes

Allows you to identify which sub-nodes will be used in identifying duplicate nodes in marshalling operations.

Eliminate Duplicates

Eliminate Duplicate Child Nodes from Combined Result

Group

Group Instances of Selected Node in Combined Result

Optimized Combine

Optimized Combine by Adding Combine Keys for Selected Combined Node to ORDER BY clause

Allows you to optimize combine performance during marshalling by executing the combine as an ORDER BY clause in the SELECT statement generated during marshalling. Visible only when Select Sort/ORDER BY Method option is set to Optimize Combine Using Order By.