Skip to main content
Previous sectionNext section

QueryProcedures

Specify whether all class queries project as SQL Stored Procedures.

Synopsis

[SQL]    QueryProcedures=n

n is either 1 or 0. The default value is 0.

Description

When QueryProcedures is enabled (n = 1), all SQL class queries project as SQL Stored Procedures, regardless of the query’s SqlProc value. When this parameter is not enabled, only class queries defined with SqlProc=1 project as Stored Procedures.

When changing this setting, you must recompile the classes with the class queries in order for this change to have an affect. Modifying this setting in the CPF does not require a n instance restart to make it active.

Changing This Parameter

To set the desired value for QueryProcedures from the Terminal, use the SetPARAMETER() method of the %SYSTEM.SQL class. See the class reference for details.

You can also change QueryProcedures with the SetQueryProcedures() class (as described in the class reference) or by editing the CPF in a text editor (as described in the Editing the Active CPF section of the “Introduction to the Configuration Parameter File” chapter in this book).