Analytica Business Systems: Pervasive.SQL and Btrieve Specialists

Pervasive.SQL, Btrieve and More KnowledgeBase | Article #61 | Control Center Won't Output to Query Plan Viewer
View an Article   Back
Title: Control Center Won't Output to Query Plan Viewer 
Category: Pervasive.SQL PSQL 9, 9.5 
Keywords: pcc, control center, qpv, query plan viewer, registry 
Description: Problem:
PCC won't output a QPV file. I've made the registry entries for QryPlan and QryPlanOutput but it still doesn't output anything.

Solution:
The PSQL v9 Control Center is a JDBC application, not an ODBC application. Query Plan Viewer uses ODBC to output the query plan data.

You can either use a third-party SQL tool, or use a built-in SET command that's a new feature in PCC. Here's the syntax for that:

In the PSQL Control Center, go to File | New | SQL Document. When the "Select Database" dialog opens, select the database for which you want to turn on QPV. In the new SQL Document window, enter:

SET qryplanoutput = '';

For example:

SET qryplanoutput = 'c:\pvsw\demodata\qryplan.qpf';

To turn it off, enter:

SET qryplanoutput = '';

That's it. 
Approved

If you like our free Pervasive Knowledge Base Service, please consider purchasing your next Pervasive Software Product from our online store or call or email us!

In the meantime, to help us keep this service free, would you mind clicking on one of the ads at the left? Thanks for visiting!