Suppose you have an external function func1 that is set to handle NULL values and has a cost per invocation set to 40. The following ALTER ROUTINE statement adjusts the settings of the function by dropping the ability to handle NULL values, tunes the func1 by changing the cost per invocation to 20, and indicates that the function can execute in parallel:
ALTER ROUTINE func1(CHAR, INT, BOOLEAN)
WITH (
DROP HANDLESNULLS,
MODIFY PERCALL_COST = 20,
ADD PARALLELIZABLE
)
Because the name func1 is not unique to the database, the data type parameters are specified so that the routine signature is unique. If this function had a Specific Name, for example, raise_sal, specified when it was created, you could identify the function with the following first line:
ALTER SPECIFIC ROUTINE raise_sal
Related Statements: ALTER FUNCTION , ALTER PROCEDURE, CREATE FUNCTION, CREATE PROCEDURE, DROP FUNCTION , DROP PROCEDURE , and DROP ROUTINE .
For a discussion of how to create and use SPL routines, see the IBM Informix Guide to SQL: Tutorial.
For a discussion of how to create and use external routines, see IBM Informix User-Defined Routines and Data Types Developer's Guide.
For information about how to create C UDRs, see the IBM Informix DataBlade API Programmer's Guide.