For iSeries Access ODBC: Problem with ORDER BY clause
Probable cause:
The iSeries Access ODBC driver reports "Y" to the property SQL_ORDER_BY_COLUMNS_IN_SELECT (ODBC 2.0). A character string of "Y" implies that the columns in the ORDER BY clause must be in the select list. Some common desktop reporting applications either ignore or do not check this value and attempt to use an order by field which is not in the select list.