User guide

Operator reference
160 Data Integration with Sybase Avaki Studio
Order By properties
Double-click an Order By operator to display the Order By Properties dialog. You can
edit the name and description as described in “Properties dialogs” on page 58.
Specifying the sort criteria
In the Order By Properties dialog, you list the columns from the input that the operator
will use to sort the incoming rows. If you choose to sort by multiple columns, Studio
sorts by the first column first; then, within the rows where that column’s value is the
same, it sorts by the second column, and so on. Each column can be sorted in either
ascending or descending order.
• Click the Add button to add a column criterion to your sorting.
• To delete one or more criteria, select them and click Delete.
• To reorder the criteria, select one or more of them and click the Move Up or Move
Down buttons. (If you want to move multiple sort criteria, the selection must be
contiguous.)
• You can edit the properties of each criterion.
 Name: Click in the Name field and choose a column name from the pull down
list to change it. (When you add a new column, Studio chooses the next avail-
able column from the input, which may not necessarily be the column you want
to sort on).
 Direction: Choose the direction in which this column should be sorted—either
“Ascending” or “Descending.”