As to OPNQRYF, things are better at 7.2 -
With 7.2, some native database access begins to use SQE by default,
* Work with Query (WRKQRY) command, when one of the run options is used
* Run Query (RUNQRY) command
* Open Query File (OPNQRYF) command
This does make the question of converting from OPNQRYF to true SQL a
murkier one, I think - AND it lets us leave the OPNQRYF usage alone in
Not sure this helps the OP make a decision - except to update hardware,
not code, as others have stated.
On 12/3/2014 8:00 PM, Nathan Andelin wrote:
I think it has already been well articulated that code modernization won't
reduce resource utilization (CPU, memory, storage, etc.). It's more likely
that more compute resources will be consumed after a modernization
One exception may be if your OPNQRYF definitions are not properly aligned
with your database indexes. In that case the SQL SQE could improve
performance a lot.