First of all, you say Genero 2.02. That was released in 2006. To give you some idea of how old that is, Windows XP was the latest release of Windows, and iPhone had not been invented yet. It is unlikely that any of the servers that Genero 2.02 was supported on are still supported by their manufacturers. You say AIX, latest AIX that Genero 2.02 was supported on was AIX 6.1 and I think that End of Support date was 30th April 2017.
I would strongly recommend you (or anyone else reading this in a similar position) consider upgrading to latest 3.10 version.
(a reminder that supported systems documentation can be found with the Documentation download for recent releases, and for older releases in the Archived Releases area on the Product or Documentation downloads page of our website).
With regards your question, do you need to being using ORDER BY? A common error developers make is to use the same ORDER BY clause in their SQL statement that gets the data for the report, and in the definition of the REPORT. End result, is you end up sorting the data twice into the same order. To avoid this unnecessary processing, in your REPORT you can use the ORDER EXTERNAL BY clause ...
http://4js.com/online_documentation/fjs-fgl-manual-html/#fgl-topics/c_fgl_reports_Two_Pass_Reports.htmlhttp://4js.com/online_documentation/fjs-fgl-manual-html/#fgl-topics/c_fgl_reports_The_ORDER_BY_Section.html... and thus a temporary database table does not need to be created.
You can also check some of the other possible causes listed alongside the 1329 error in the documentation
http://4js.com/online_documentation/fjs-fgl-manual-html/#fgl-topics/r_fgl_errors_001.html (index name already used, no diskspace, open file limit)
Finally why did the error start occurring now. Are you writing a new report, or modifying an existing report? Did you perhaps go from 8 to 9 values in the ORDER CLAUSE.
Reuben