Skip to main content

This documentation is for an older version of this product. See the latest version of this content.Opens in a new tab

ExtrinsicFunctions

Enable extrinsic functions in SQL statements.

Synopsis

[SQL]    ExtrinsicFunctions=n

n is either 1 or 0. The default value is 0.

Description

When ExtrinsicFunctions is enabled (n = 1), extrinsic functions can be used in SQL statements through ODBC, JDBC, and Dynamic Query.

For further details, refer to the SELECT command.

Changing This Parameter

To set the desired value for ExtrinsicFunctions from the Terminal, use the SetOption(“AllowExtrinsicFunctions”)Opens in a new tab method of the %SYSTEM.SQL.UtilOpens in a new tab class. See the class reference for details.

You can also change ExtrinsicFunctions with the Config.SQLOpens in a new tab class (as described in the class reference) or by editing the CPF in a text editor (as described in Editing the Active CPF).

FeedbackOpens in a new tab