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?

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

Feedback