Sorting data for a write operation

The availability of the Sort option depends on the partitioning or collecting method that you select on the Partitioning tab in the stage editor. You cannot sort data if you select the Auto or Db2® connector partition or collection type.


  1. Select the Sort check box.
  2. To retain previously sorted data sets, select one or both of the following options:
    • Select the Stable check box if you want to preserve previously sorted data sets.
    • Select both Stable and Unique as well if you want to retain only one of the multiple records that have identical sorting key values. In this case, the first record of the records that have identical sorting key values is retained.
  3. Click OK.