This dialog is useful when you want to order nodes in your XML output file, and you have set the nodes to use the Order By option (the default option). If you select more than one XML node to add to the ORDER BY clause in the automatically generated SELECT statement for marshalling, you may need to change the order in which they appear in the ORDER BY clause. For example, if you set ORDER BY on both employee ID and department name, you would want to order by department name first, then employee ID.
To set a sequence:
In the XML Structure tab, click in the Order By column for each of the nodes that you want to sort on.
From the drop-down menu, choose the order you want to use in sorting.
The current sequence is displayed in parentheses in the Order By column. To change the sequence:
Click 
in the XML Structure toolbar to open the "Set Database
Column/Expression Sequence in ORDER BY Clause dialog.
In the dialog, select the row you want to change.
Using the buttons at the right of the screen, move the row up or down to set the sequence you want.
Click OK to close the dialog.
The Order By column in the XML Structure tab should now display the sequence you set in the dialog.
How to Access the Set Sequence in ORDER BY Clause Dialog
In the XML Structure tab toolbar, click
. This icon is available only when the 
Select Sort/ORDER BY Method option is
set to Sort XML Output Records Using
ORDER BY.