Skip to main content

This is documentation for Caché & Ensemble.

For information on converting to InterSystems IRIS, see the InterSystems IRIS Adoption Guide and the InterSystems IRIS In-Place Conversion Guide, both available on the WRC Distributions page (login required).

Previous sectionNext section

QueryProcedures

Defines whether all class queries project as SQL Stored Procedures.

Synopsis

[SQL]    QueryProcedures=n

Description

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.

Examples

QueryProcedures=1

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).

FeedbackOpens in a new window