Skip to main content

This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.

For information on migrating to InterSystems IRIS, see Why Migrate to InterSystems IRIS?


Defines whether all class queries project as SQL Stored Procedures.


[SQL]    QueryProcedures=n


Defines whether or not all class queries project as SQL Stored Procedures regardless of the query's SqlProc setting. Default is 0. Only class queries defined with SqlProc=1 project as Stored Procedures. When set to 1, all class queries 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 file does not require a system restart to make it active.



Range of Values

0 or 1. The default is 0.

Management Portal

On the page System Administration > Configuration > SQL and Object Settings > General SQL Settings, in the All Class Queries Project as Stored Procedures setting, select Yes (to project queries as stored procedures) or No (the default).