Hallo DAN,
falls Du R520 auf der AS/400 hast, könnte die Lösung auch
die Installation eines Neueren Servicepacks für Client Access
sein, denn

ORDER BY Column Not in the Result Set

Some ODBC applications attempt to use a field in the ORDER BY clause that does not exist in the result set. This results in the following error:

SQL0208 - ORDER BY column 'column_name' not in result

Support for this feature was added in DB2 UDB for iSeries in R520. Client Access ODBC reports support for this to applications through the SQLGetInfo API: SQL_ORDER_BY_COLUMNS_IN_SELECT=90. Note that only R520 and later (with a service pack after SI04684) report "N". Older versions report "Y" informing applications that the column used in the ORDER BY clause must be in the select list.

Servicepack Download:
ftp://ftp.software.ibm.com/as400/pro...epack/si09809/

Gruss TARASIK