Keywords That Introduce Modifications

Use these keywords to introduce the items in the UDR that you want to modify:

Keyword	Effect
ADD	Add a routine modifier to the UDR
DROP	Delete a routine modifier from the UDR
MODIFY	Change an attribute of the routine modifier
MODIFY EXTERNAL NAME (for external routines only)	Replace the file specification of the executable file. When the IFX_EXTEND_ROLE configuration parameter = ON, this option is valid only for users to whom the DBSA has granted the EXTEND role. With IFX_EXTEND_ROLE = OFF (or not set), the UDR owner or the DBA can use this option.
WITH	Introduces all modifications

For example, both of the following statements alter the func1 UDR so that it can be executed in parallel in the context of a parallelizable data query statement:

ALTER ROUTINE func1 WITH (MODIFY PARALLELIZABLE); 
ALTER ROUTINE func1 WITH (ADD PARALLELIZABLE);