EXECUTE FUNCTION

>>-EXECUTE FUNCTION--------------------------------------------->
 
                                                                          (3)  (1) (4)
>--+-+-function-------+--(--+-----------------------+--)--| INTO Clause |---------------+-><
   | |  (1)           |     | .-,-----------------. |                                   |
   | '--------SPL_var-'     | V              (2)  | |                                   |
   |                        '---| Argument |------+-'                                   |
   |  (5)    (6)                                   (7)                                  |
   +---------------| IFX_REPLACE_MODULE Function |--------------------------------------+
   |  (5)    (8)                           (9)                                          |
   '---------------| jvpcontrol Function |----------------------------------------------'

Notes:

Stored Procedure Language only
See Arguments
See INTO Clause
ESQL/C only
Dynamic Server only
C only
See IFX_REPLACE_MODULE Function (IDS, C)
Java only
See The jvpcontrol Function (Java)

Element	Description	Restrictions	Syntax
function	Name of a user-defined function to execute	Must be registered in the database	Database Object Name
SPL_var	Variable that contains the name of an SPL routine to be executed	Must be a CHAR, VARCHAR, NCHAR, or NVARCHAR data type that contains the non-NULL name of an existing SPL function	Identifier

The EXECUTE FUNCTION statement invokes a user-defined function (UDF), with arguments, and specifies where the results are to be returned.

An external function returns exactly one value.

An SPL function can return one or more values.

You cannot use the EXECUTE FUNCTION statement to execute any type of user-defined procedure that returns no value. Instead, use the EXECUTE PROCEDURE or EXECUTE ROUTINE statement to execute procedures.

You must have the Execute privilege on the user-defined function.

If a UDF has a companion function, any user who executes the function must have the Execute privilege on both the function and its companion. For example, if a function has a negator function, any user who executes the function must have the Execute privilege on both the function and its negator.

For more information, see GRANT.

EXECUTE FUNCTION

Syntax

Usage