Sort stage: Properties section

Use the Properties section on the Stage tab to specify how the Sort stage operates.

The Properties section allows you to specify properties which determine what the stage actually does.

The following table gives a quick reference list of the properties and their attributes. A more detailed description of each property follows.

Table 1. Properties
Category/Property	Values	Default	Mandatory?	Repeats?	Dependent of
Sorting Keys/Key	Input Column	N/A	Y	Y	N/A
Sorting Keys/Sort Order	Ascending/Descending	Ascending	Y	N	Key
Sorting Keys/Nulls position (only available for Sort Utility = DataStage®)	First/Last	First	N	N	Key
Sorting Keys/Sort as EBCDIC	True/False	False	N	N	Key
Sorting Keys/Case Sensitive	True/False	True	N	N	Key
Sorting Keys/Sort Key Mode (only available for Sort Utility = DataStage)	Sort/Don't Sort (Previously Grouped)/Don't Sort (Previously Sorted)	Sort	Y	N	Key
Options/Sort Utility	DataStage/ UNIX	DataStage	Y	N	N/A
Options/Stable Sort	True/False	True for Sort Utility = DataStage, False otherwise	Y	N	N/A
Options/Allow Duplicates (not available for Sort Utility = UNIX)	True/False	True	Y	N	N/A
Options/Output Statistics	True/False	False	Y	N	N/A
Options/Create Cluster Key Change Column (only available for Sort Utility = DataStage)	True/False	False	N	N	N/A
Options/Create Key Change Column	True/False	False	N	N	N/A
Options/Restrict Memory Usage	number MB	20	N	N	N/A
Options/Workspace	string	N/A	N	N	N/A