SORT Limitations

Following are important considerations to observe when constructing SORT statements.

Ten control breaks in a SORT statement is the maximum allowed.
The total length of columns/keys used in a SORT statement cannot exceed 100 characters. (An extra character is added for each signed numeric column.)
SQL DATE, TIME and TIMESTAMP cannot be used with DQL SET, SORT and WITH.