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

SqlProc

Specifies whether the query can be invoked as an SQL stored procedure.

Usage

To specify that the query can be invoked as an SQL stored procedure, use the following syntax:

Query name(formal_spec) As classname [ SqlProc ]
{
   //implementation
}

Otherwise, omit this keyword or place the word Not immediately before the keyword.

Details

This keyword specifies whether the query can be invoked as an SQL stored procedure.

Default

If you omit this keyword, the query cannot be invoked as an SQL stored procedure.

See Also