Tips to convert Progress 9.1c SQL queries to OpenEdge 10.1c SQL

1. Change dbName. to dbName.pub.
2. All BY statements need to be changed to ORDER BY.
3. Any field in the field-name format (with the - sign) need to have quotes ie: "field-name".
4. The following words need to be in quotes:
        sequence
        cycle
5. All empty fields or constants should be in single quotes '', not double "".
6. Replace today function with SYSDATE.
7. Use PRO_ELEMENT(field, #) function for fields with extents.
8. Replace DESCENDING with DESC.