Caché Parameter File Reference
QueryProcedures
[Home] [Back] [Next]
InterSystems: The power behind what matters   
Class Reference   
Search:    

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