However, while it runs against a MS access database, it has problems with the iSeries. ... we ran a debug trace and it was observed that for this particular SQL statement, the ORDER BY clause is getting cutting off.
The datasource type really has nothing to do with how ColdFusion generates that sql string. ColdFusion first evaluates the cfswitch/cfcase statements, then sends the final sql string to the chosen datasource. So it produces the same string no matter the datasource type.
What is more likely is that your #sort# value did not match any of the cfcase values. Since there is no default case, nothing is added to the ORDER BY, making it seem like the statement was truncated.
Thanks for taking the time to comment.
Per your suggestion I searched on the web and found a very effective table sorter in JS. Thanks!