Use the _QRWENABLE reset
option to disable the SQL Query Rewrite Facility. You might use this
option if you suspect that the SQL Query Rewrite Facility is not enhancing
the performance of the SQL query execution. The SQL Query Rewrite
Facility is enabled by default.
Disable SQL Query Rewrite
Facility:
execute(reset no_qrwenable) by sasspds; /* Disable query rewrite */
execute(reset _qrwenable=0) by sasspds; /* Another way to disable */
Re-enable SQL Query
Rewrite Facility:
execute(reset _qrwenable) by sasspds; /* Re-enable query rewrite */
execute(reset _qrwenable=1) by sasspds; /* Another way to enable */