Enabling and disabling user-defined functions

Sybase IQ includes a security feature, external_procedure_v3, which enables or disables the ability of a server to make use of high performance in-process UDFs.

A database should maintain data integrity. Under no circumstances should data be lost, modified, augmented, or corrupted. Since UDF execution happens within the Sybase IQ server, there is a risk of corrupting data; practice caution with memory management and any other use of pointers. Sybase strongly recommends that you to install and execute UDFs within a read-only multiplex node. For added protection, use a startup option in each IQ server to enable or disable the execution of UDF.

Note: By default, UDF execution on a multiplex writer and coordinator nodes are disabled.. All other nodes are enabled by default.

Administrators can enable version 3 UDFs for any server by specifying this in the server startup command or in the configuration file:

-sf -external_procedure_v3

Administrators can disable version 3 UDFs for any server by specifying this in the server startup command or in the configuration file:

-sf external_procedure_v3

Additional information on the -sf flag is available in the SQL Anywhere Server - Database Administration guide. Do not use the values listed in the SQL Anywhere document which are applicable to Sybase IQ.