DYNCOL Select Order By Problem

If you want to have ORDER BY in the query for DYNCOL, you must include the columns you want to order by in the select statement.

Following statement will not work:

select custgroup from table order by custgroup, unit

You must include 'unit' in the select for this to work:

select custgroup, unit from table order by custgroup, unit