Can you consider extending the LOAD statement so that an ORDER BY clause can be specified for a non-resident load ?
Yes there will be a minor performance hit, but no worse then having to use a temporary table, resident load and drop statement. Easier code = easier lives.
Thank you for your feedback on ways to improve our product. While this is something we understand would be useful, it's not on the short-term roadmap. Please continue to show your support for this idea.
NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.