SAS Safety Scalable Performance Data Server 4.5 Manual Do Utilizador

the performance of the SQL query execution. The SQL Query Rewrite Facility is enabled
by default.

Examples:

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 */

Use the _QRW reset option to enable diagnostic debugging and tracing outputs from the
SQL Query Rewrite Facility in the log. The diagnostic debugging option is disabled by
default.

Examples:

Enable diagnostic debugging function:

execute(reset _qrw) by sasspds; /* Enable diagnostics */
execute(reset _qrw=1) by sasspds; /* Another way to enable */

Disable diagnostic debugging function:

execute(reset no_qrw) by sasspds; /* Disable diagnostics */
execute(reset _qrw=0) by sasspds; /* Another way to disable */