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 How to Migrate to InterSystems IRIS, available on the WRC Distributions page (login required).


Enable/disable extrinsic functions in SQL statements.


[SQL]    ExtrinsicFunctions=n


The value n may be 1 or 0:

  • When 1 (true) extrinsic functions can be used in SQL statements through ODBC, JDBC, and Dynamic Query.

  • When 0 (false) this feature is disabled.



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, for the Allow Extrinsic Functions in SQL Statements setting, choose Yes (true) or No (false).