What kind of SQL changes/enhancements needed when you migrate from DB2 v8 compatibilty mode to new function mode. I am giving one example of SQL change (ORDER by Clause) :
Collating sequence (ordering):
Compatibility Mode = EBCDIC
New Function Mode = ASCII
So please let me know where can i find the list of all changes needed from application (like compiler options etc) and SQL perspective.