Unless the optimizer chooses to do a sort to satisfy the ordering request, the sort sequence table associated with the index must match the sort sequence table associated with the query.
When a sort is used, the translation is done during the sort. Since the sort is handling the sort sequence requirement, this allows DB2 UDB for AS/400 to use any existing index that meets the selection criteria.