String comparison

IBM® DataStage® sorts string values according to general rules.

The string values are sorted according to the following rules:

• Characters are sorted in lexicographic order.
• Strings are evaluated by their ASCII value.
• Sorting is case sensitive, that is, uppercase letters appear before lowercase letter in sorted data.
• Null characters appear before non-null characters in a sorted data set, unless you specify the nulls last option.
• Byte-for-byte comparison is performed.